How can I connect to an Azure DB from Power BI Desktop using a Service Principal Certificate

[ruixu]

Hi Team, 

Is there a way to Azure DB from Power BI Desktop using a Service Principal Certificate or Client Secret?

[Anonymous]

Hi @ruixu ,

I think you may try to create a Azure service principal follow this offical blog.

Create an Azure service principal with Azure PowerShell

 If you already have a service account and you want to use it to authenticate to a data source just give it the necessary permissions as described below:
Create a Login 

You can try to assigned service principal the db owner permissions and the data refresh from service should work.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ruixu]

The DB has been configured. What I want is to connect Azure DB from Power BI Desktop using service principal certificate mode. 

[rajendraongole1]

Hi @ruixu - Please check the below link that helps to connect azure sql DB via service principal certificate

Solved: Access Azure SQL DB from Power BI using service pr... - Microsoft Fabric Community

How to Connect to Azure SQL Database from Power BI Desktop Using Service Principal? : r/PowerBI (red...

Solved: Service Account used to connect a dataset to Azure... - Microsoft Fabric Community

Hope it helps.

[ruixu]

These responses all state that Power BI Desktop does not support the service principal authentication mode (both certificate and client secret) so far.