Authentication Method for Refreshing Power BI Dataset (Azure SQL Source)

Hi kankamon ,

Apologies for the late reply.
I have included the troubleshooting learning document and the previously resolved thread. This may help you to resolve the issue.

Troubleshoot scheduled refresh for Azure SQL databases - Power BI | Microsoft Learn

Solved: SQL Azure Import Data Refresh - Microsoft Fabric Community

If this post helped resolve your issue, please consider the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana.

Hey kankamon ,

To use the certificate for your Service Principal in Power BI, follow these steps:

1. Upload the Certificate in Azure AD:

   • Go to Azure AD > App Registrations > Your Service Principal > Certificates & Secrets.

   • Upload your certificate there.

2. Configure Power BI:

   • In Power BI Service, go to Settings > Datasets > Data source credentials.

   • Choose Service Principal (App-only authentication).

   • Instead of using a client secret, Power BI will now use the certificate you uploaded in Azure AD.

Basically, the certificate is linked to the Service Principal in Azure AD, and Power BI will use it for authentication during the refresh.

For Detailed Information:

Create a Service Principal in Azure AD

Configure certificates for Azure AD App Registration

Configure Service Principal authentication for Power BI

Power BI Data Source Credentials Documentation

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam