Forum Discussion
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:
Upload the Certificate in Azure AD:
Go to Azure AD > App Registrations > Your Service Principal > Certificates & Secrets.
Upload your certificate there.
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
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.
Hi kankamon ,
If your question has been answered, kindly mark the appropriate response as the Accepted Solution. This small step goes a long way in helping others with similar issues.
We appreciate your collaboration and support!
Best regards,
LakshmiNarayanaHi kankamon ,
As we haven't heard back from you, we are closing this thread. If you are still experiencing the same issue, we kindly request you to create a new thread we’ll be happy to assist you further.
Thank you for your patience and support.
If our response was helpful, please mark it as Accepted as Solution and consider giving a Kudos. Feel free to reach out if you need any further assistance.
Best Regards,Lakshmi Narayana