Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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
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>
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
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.
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.
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
39 | |
21 | |
21 | |
19 | |
10 |
User | Count |
---|---|
35 | |
35 | |
34 | |
20 | |
14 |