Forum Discussion

skygold16's avatar
skygold16
Icon for Helper II rankHelper II
3 years ago

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 ...
Need Help
foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
Luxata
Icon for Advocate I rankAdvocate I
2 years ago

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.