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 (11)
RE: Service principal with Power BI and Data Gateway
9'th March 2023 - still looking for this functionality. The requirement to manually connect to the DataGatewayCluster with an non-SPN admin account in order to add an SPN to the user list of a datasource is frustratingBeing able to take care of such an activity with an SPN via a script will let me add automate this processPlease make it so!
RE: Service principal with Power BI and Data Gateway
HiFor the moment , Powershell can help you https://blog.jpries.com/2021/11/25/adding-a-non-email-enabled-object-to-power-bi-gateway-cluster-users/
RE: Service principal with Power BI and Data Gateway
2021, it would still be great to have this capability
RE: Service principal with Power BI and Data Gateway
This is blocking automation that the API otherwise provides. You allow SPN to use the API and be a workspace Admin. Why not Gateway?
RE: Service principal with Power BI and Data Gateway
I take it for granted that a Service Principal should be able to authenticate and retrieve information from Azure SQL Server. How else to handle data sources in various reporting solutions in a secure way and which also handles rotation of the organization's staff? We don't want report credentials to be personal and using old fashion SQL Server Authentication is not a good alternative to this.
RE: Service principal with Power BI and Data Gateway
To follow this https://devblogs.microsoft.com/premier-developer/secure-access-to-azure-sql-servers-for-power-bi/ and stick with our principle not to use local SQL logins we need this feature ASAP
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
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
RE: Service principal with Power BI and Data Gateway
'+ 1 we need it