Forum Discussion
Best Practice Authentication for Cloud Connection (SharePoint List)
Hi all!
In my Company we are using a SharePoint Online List as Data Source for a Power BI Report. Now I need to configure a scheduled refresh for this Report and I have to create new Cloud Connection.
I am wondering what is the best practice for the Authentication method. I think I will need OAuth2.0 but I am not sure. I am not familiar when to use the option "Anonymous" or "Service Principal".
Do I need an extra MS 365 service account (when using OAuth2.0) with access to the sharepoint site? I think I have to insert the credentials here in the "Edit credentials" section. I am a little bit confused.
Thanks for your help!
You want OAuth 2, anonymous won't work. 🙂
You don't need a service account/principal, but if you don't have one and you leave your organization, your refreshes will all start failing. Service account is usually easier to get up and running, unless you have people who know what they're doing in Azure.
2 Replies
You want OAuth 2, anonymous won't work. 🙂
You don't need a service account/principal, but if you don't have one and you leave your organization, your refreshes will all start failing. Service account is usually easier to get up and running, unless you have people who know what they're doing in Azure.
