The OAuth authentication method isn't supported for this data source.

[skygold16]

Hi Experts, 

I have few reports in Power BI service which is reading data from the excel files store on SharePoint Team sites.

I used the SharePoint folder connector to read the excel file. The refresh to these reports was schedule which suddenltly got disabled due to credential issues. 

When I try to re-enter the credentials using oauth I get the following error:

The OAuth authentication method isn't supported for this data source. Contact your admin.Show details

Tried few different reports in different workspace and in premium workspace too. Nothing seems to be working and looks like all the reports reading data from the excel st

[Luxata]

Hi this is late but , If you remove the X/:R/ in the document path  (in advanced editor) it will work. 

[DiegoVillalvazo]

This fixed the error for me. Thanks!

[foodd]

Hi @Luxata,.  To clarify, are you referring to Neil Hoff's response on Stack Overflow comparing SharePoint Path and Excel Path?

1
If you pull the url of the file from SharePoint remove the :x/r/ from it. Otherwise use Excel to pull the url.
SharePoint Path vs. Excel Path
	• https://company.sharepoint.com/:x:/r/sites/subsite/file.xlsx <-- Oauth fails
	• https://company.sharepoint.com/sites/subsite/file.xlsx
In Excel, click on File -> Info -> Copy Path 

Share
Improve this answer
Follow
answered Sep 27, 2023 at 17:17

Neil Hoff
2,03544 gold badges2929 silver badges53

From <https://stackoverflow.com/questions/72430563/how-to-fix-the-message-the-oauth-authentication-method-isnt-supported-for-this> 

[Luxata]

I believe this is where I saw it yes, and it worked for me.. Sorry if i didnt give the credits to Neil Hoff. I just couldn't remember where i saw the solution. 

[SaiTejaTalasila]

Hi @skygold16 ,

You can try to load that data to a dataflow and see whether it is working or not.If it works then on the dataflow settings you can check what kind of authentication it is using.If still you are unable to find the resolution you check whether anything change on your SharePoint access level.

Thanks,

Sai Teja 

[gp10]

I have the same issue now and then, its fixed without doing anything special, just opening the settings of another dataset and then returning and opening once again the settings of the dataset that faces the issue solved it for me.

[v-zhangti]

Hi, @skygold16 

When connecting to data sources and services that require authentication through OAuth or Azure Active Directory-based authentication, in certain cases where the service is configured correctly, you can use the built connectors to authenticate and connect to data without requiring a service-specific or custom connector.

Power Query SharePoint list connector - Power Query | Microsoft Learn

More details: Authentication with a data source - Power Query | Microsoft Learn

I have also found a similar post, please refer to it to see if it helps you.

powerbi - How to fix the message The OAuth authentication method isn't supported for this data sourc...

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.