Forum Discussion
Cannot use PowerBi data source to connect with SharePoint
Several of our users gets various error messages(in Dutch), for example:
"The Oauth authentication method is not supported for this data source"
"The refresh token has probably expired. Go to the dataset setup page and re-enter the Oath2 credentials for the sharepointlist data source"
-Both the Oauth2 and Anonymous authentication methods have been used, but the issue persists
-MFA CA policies have been excluded for the user's account [email protected] which is used to authenticatie, but the issue persists.
-When I login as administrator under the app.powerbi.com evironment, I cannot access the data source.
I am not experienced with PowerBi, could you help me out? How can I as an administrator refresh the token or make it so that the Oauth or a different authentication method does becaome valid for the SharePoint data source?
1 Reply
Hi. That's really weird. How are you connecting your data?
I have always used the following methond and never had issues, not even with MFA
https://blog.ladataweb.com.ar/post/185337134590/alternativa-para-conectar-power-bi-a-onedrive
Using the path route for the excel file on a web content should work. Be sure that all the tables connected with sharepoint are using the exact same method.
I hope that helps,
