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>

 

SaiTejaTalasila's avatar
SaiTejaTalasila
Icon for Super User rankSuper User
2 years ago

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