How do you connect to an excel document on sharepoint?

[Anonymous]

Hi,

I currently connect to an excel document on sharepoint, however when trying to add it to gateway it says outh authentication is not available?

Any help appreciated?

[Anonymous · Accepted solution]

Hi Amitchandak,

For some reason OUTH authentication doesnt work that way using the web connector, I managed to get it to work but had to use the sharepoint connector.

For example

    Source = SharePoint.Files("https://site.sharepoint.com/Referrals", [ApiVersion = 15]),
    #"Referral Tracker xlsx_https://site sharepoint com/Referrals/Shared Documents/" = Source{[Name="Referral Tracker.xlsx",#"Folder Path"="https://site .sharepoint.com/Referrals/Shared Documents/"]}[Content],
    #"Imported Excel Workbook" = Excel.Workbook(#"Referral Tracker xlsx_https://site sharepoint com/Referrals/Shared Documents/"),
    Children_Sheet = #"Imported Excel Workbook"{[Item="Children",Kind="Sheet"]}[Data],

[amitchandak]

@Anonymous , Please refer to this, you have open excel on the desktop and get a link(Same for SharePoint and one drive), remove the part after the file name (?web=1)

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links