Skip to main content

Power BI

New

Service principal with Power BI and Data Gateway

Vote (32) Share
's profile image

on 09 Mar 2019 00:37:32

Currently the Service principal account cannot leverage the On-Premises Data Gateway since it is not a mail-enabled account. This prevents a Power BI Embedded solution to leverage an on-premises SSAS tabular model leveraging the service principal. Instead we need a full-blown power BI pro license for a service account. I would like the capability to leverage the data gateway added to the service principal Power BI authentication.

Comments (4)
's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:17:16

RE: Service principal with Power BI and Data Gateway

There are lots of limitations spn gateway access which is public preview

please see below

https://github.com/jayendranarumugam/GatewayAutomation/blob/master/README.md#limitation-as-of-may-2020

's profile image Profile Picture

cf414d10 538a-46c6-828f-802d8d617ae5 on 06 Jul 2020 00:14:34

RE: Service principal with Power BI and Data Gateway

The spn access for gateway alone is in public preview

https://community.powerbi.com/t5/Community-Blog/Data-Gateway-Automation-using-PowerShell-Part-1/ba-p/1117330

's profile image Profile Picture

90b32563 9b26-4777-9f0b-6b94b2a331e8 on 06 Jul 2020 00:11:12

RE: Service principal with Power BI and Data Gateway

'+ 1 we need it

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:02:22

RE: Service principal with Power BI and Data Gateway

It is much needed when we automation everything using the SPN, since most of our reports using the gateway using the SPN it's currently not possible. Please add this capability