Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
skygold16
Helper II
Helper II

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

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

7 REPLIES 7
Luxata
Frequent Visitor

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

This fixed the error for me. Thanks!

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
Frequent Visitor

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. 

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
Advocate III
Advocate III

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
Community Support
Community Support

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.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.