Forum Discussion
Question: Authentication Method for Refreshing Power BI Dataset (Azure SQL Source)
Hi kankamon ,
Currently, the available authentication options are Basic, Anonymous, OAuth2, and Service Principal. If you choose to authenticate using a Service Principal, a Service Principal Key is required. If these options do not meet your requirements, and If any alternate feature is important for your functionality Please consider sharing your suggestion in the Power BI Ideas forum
Fabric Ideas - Microsoft Fabric Community,
where the product team actively monitors user feedback. Ideas with strong community support are more likely to be considered for future implementation. Posting there helps ensure your request reaches the right audience and contributes to shaping the product roadmap.
Thank you
Hi sir, thank you for your helpful answer.
Following your advice, I asked my engineer to create a certificate for our Service Principal instead of a client secret. However, we don't know where to use this certificate in the Power BI Service.
When we navigate to the data source credentials, the field labeled "Service principal key" seems to expect a client secret, not a certificate.
Could you please clarify where we should put the certificate on?
Hi kankamon ,
Currently, the available authentication options are Basic, Anonymous, OAuth2, and Service Principal. If you choose to authenticate using a Service Principal, a Service Principal Key is required. If these options do not meet your requirements, and If any alternate feature is important for your functionality Please consider sharing your suggestion in the Power BI Ideas forum
Fabric Ideas - Microsoft Fabric Community,
where the product team actively monitors user feedback. Ideas with strong community support are more likely to be considered for future implementation. Posting there helps ensure your request reaches the right audience and contributes to shaping the product roadmap.
Thank you
Hi kankamon ,
Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.
If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.