Source Problem in a shared file - Power query

[campelliann]

Hi,

I have an excel file which I share with my team on teams/sharepoint. I have no problems refreshing the queries but my colleagues do. All the data comes from a share folder, I made a sync from teams/sharepoint of the source files to my computer, so in the source file path in power query you can see my C:\users\my name\ my enterprise name etc. 

How I can I get around this?  Here is the the error my colleagues met: "DataSource not found file or folder". I assume I must change the source without mention my c:?

[edhans · Accepted solution]

You need to reconnect to the file using the SharePoint link, not the C drive link. I am assuming you have sync'd that to your PC. Your co-workers have a different path if they are syncing it.

Go to the sharepoint site and get the site address. It will be something like:

https://tenantname.sharepoint.com/sites/sharepointsitename

You'll get a source in your M code that will look like SharePoint.Files(). If you have just a few files, less than 1,000 or so, that is fine. If you have a lot in that site, change it to SharePoint.Contents() - note it is case sensitive.

No matter which you use, you can filter to fined the file if using SharePoint.Files, or drill down using SharePoint.Contents().

Once you get the file loaded, you can go into the advanced editor and copy all of that code to your existing query replacing the Source and naviation lines.

If you need help, post back with your code, or see the link below which will assist with swapping out source and transformation data in M code. 

See this article if you need help using this M code in your model. 

[ayahAsh]

can you make a video showing how to do it

[camargos88]

Hi @campelliann ,

You should use the sharepoint file address to avoid more problems.

This address "C:\users\my name\.." is local in your computer.

Also even it's shared you need to input the source with the server in the path.