Power Query - Could not find a part of the path error.

Copper Contributor

Hi 

I have read some of the posts on PQ sourcing errors, but mine seems a little bit different. As a team, we are working on a PQ file. We are sourcing our excel files from OneDrive. The path seems to always start with the personal user id, so when another user goes in the file - PQ displays an error. Every time we switch users, we have to browse the data sources one by one, even why they are located on the same folder as before.

We tried saving the files on a local drive - it fixed the problem, but it seems to slow down the performance of PQ.

 

Does anyone know a workaround?

 

Thank you in advance!

0 Replies