Change the data source from the local drive to the SharePoint folder

[DevadathanK]

Hello community!

<Message deleted>

Thanks in advance!

[amitchandak]

@DevadathanK , clear credential and try

[DevadathanK]

@amitchandak 

I tried removing all global permissions and reentering them, but it didnt work.

[Anonymous]

I did this awhile back which works.

I set up a parameter for the URL, pointing to the sharepoint location, as a base url for other documents:

SharepointLocation  = https://<sharepoint.com>/:x:/r/sites/BIDashBoardforO365/

you can get the link from going to your sharepoint site: (and trim the stuff off the end after ?, you don't need it)

Then in your Query, change to:

Source = Excel.Workbook(Web.Contents(SharepointLocation & "CountryCodes.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],

[DevadathanK]

<Message deleted>

[Anonymous]

The url is missing the extension, .xlsx