Forum Discussion
skygold16
Helper II
Helper IIThe 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 ...
Luxata
Advocate I
Advocate IHi this is late but , If you remove the X/:R/ in the document path (in advanced editor) it will work.
foodd
Community Champion
Community ChampionHi 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>
SaiTejaTalasilaSuper User
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
- 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.