Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Change source from file folder to SharePoint folder - Power query

Steel Contributor



We have some shared Excel files, which are imported and combined into one report using power query. The problem is hat the path/source is locked to the user that made the connection: c:\\user\urename

and can not be updated by other member with access.


I have found some videoes, but they use a specific file, and not combine all the files in the folder. 


What is the easiest way to solve this?


Best regards

- Geir

new source.png


0 Replies