Forum Discussion

fingalbrad's avatar
fingalbrad
Icon for Helper I rankHelper I
7 years ago
Solved

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

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 ...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago

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