DataSource.Error Changed from excel file on network drive to excel file in sharepoint

[fingalbrad]

Hi I have an excel file stored locally on my computer. I have saved the same file to sharepoint and I am trying to change my source from the local file to the share point file in the query editor by clickin on the little cog next to source in the applied steps. I changed the URL to the share point file and open file as excel workbook and I get this error. Any idea what is happening?

[v-danhe-msft · Accepted solution]

Hi @fingalbrad ,

The way to get excel file in local and in sharepoint is different.

Local file:

Sharepoint:

So, I suggest you change the whole code after Source= to change your data.

Regards,

Daniel He

[d_gosbell]

So typcially a file on Sharepoint will have a http address like:

eg.

http://myserver.com/sites/site1/library/mydocument.xslx

You can often change this to a unc style path and then your existing Power Query code will continue working. You do this by replacing the leading "http://" with "\\" and swapping all the forward slashes "/" to backward slashes "\"

eg.

\\myserver.com\sites\site1\library\mydocument.xslx