Forum Discussion
Power BI On-premises gateway cannot connect to database with service principal
Just to update here as well, I've contacted support and they confirmed this is currently not possible, even though the option is showing in the selection drop down when setting up the connection. It is not possible to use a service principal when connecting through an on-premises data gateway within a private network.
Thanks for the help everyone.
Super UserThat login has nothing to do with the operation of the gateway. It is not strictly required. (There is a bug that will prevent a new gateway version number to show up in the service until you log in, but that's it)
That's what I figured, but then I still don't understand how I'm supposed to test GilbertQ 's comment.
- lbendlin
On the gateway VM install SSMS or ADS, and then attempt the login to the db via SP from that tool.
Thanks for the clarification. I am able to connect from that server in SSMS using the service principal Application ID and token. The same credentials still give the same error in the Power BI Gateway connection settings
- lbendlin
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .