Forum Discussion

Hogstad_Raadgivning's avatar
Hogstad_Raadgivning
Steel Contributor
Jan 30, 2024

Change source from file folder to SharePoint folder - Power query

Hi,

 

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

 

  • Yea_So's avatar
    Yea_So
    Bronze Contributor

    Hogstad_Raadgivning 

     

    Seems to me that your team need to have a user group meeting to establish and agree sharing protocols on this process which can be qualified when sharing files whether it can be edited by whom.

     

Resources