Cannot use PowerBi data source to connect with SharePoint

[Fotten88]

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 S.Joosten@nester.nl 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?

[ibarrau]

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,