Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to authenticate as a service principal to a PowerBI SQL DW data source.
The way to authenticate using any other client is documented here https://docs.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication?view=... , using the client id and secret as credentials. I am unable to set these credentials to the PowerBI data source, they are being rejected.
Is there any supported way to authenticate to an SQL data source as a service principal?
On-Prem SQl database or Azure SQL ?
It's a Synapse dedicated pool. I'm trying to get PowerBI to connect to it through the service principal credentials (client id and secret). I would need to enter these credentials somewhere (the PowerBI service UI, or the equivalent REST API call), but they are not accepted.
The link you sent me is about authenticating through the ADAL python library using access tokens, I am not sure how this is applicable to my request.
Have you ever solved this? I have the same question.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.