Service principal with Power BI and Data Gateway

[pbiideas1]

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.

[pbiideas1]

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

[satisht_learn]

'+ 1 we need it

[jayendran_arumu]

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

[pbiideas1]

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

[darren_price1]

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

[jan_isacsson]

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.

[Eric_Whitt]

This is blocking automation that the API otherwise provides. You allow SPN to use the API and be a workspace Admin. Why not Gateway?

[samantha_hughes]

2021, it would still be great to have this capability

[Peter_Daniels1]

Would be really nice to be able to automate data gateway management/admin using a service principal instead of an interactive login.

[fbcideas_migusr]

Hi

For 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/