Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
It seems that the authentication method 'service principal' does not work for the SharePoint datasource in Power BI service -> dataset -> settings - edit credentials. By reading some documentation it seems that the only way to get data from the SharePoint API is via client certificates, maybe why it does not work (anymore) for client secrets. I presume this uses the SharePoint resource 'https://microsoft.sharepoint.com' and not the Graph resource 'https://graph.microsoft.com/' under the hood.
Kind regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @naelske_cronos
I found a document related to connecting to SharePoint using service principal that you can refer to. Hope this will help you.
How to connect SharePoint online using service principal? - Microsoft Q&A
Best Regards,
Community Support Team _ Ailsa Tao