Change All Queries Source Folders at once

rolo
Posts: 15
Joined: Tue Sep 27, 2016 8:14 am

Change All Queries Source Folders at once

Postby rolo » Wed Mar 15, 2017 5:59 am

Hello again Matt,

I have many queries, all of them from different excel files.
The problem is that sometimes I have to change folders or PC,
and I have to manually edit each query

For example, I have this:
Query 1: Source = Folder.Files("F:\MainDir\A\1")
Query 2: Source = Folder.Files("F:\MainDir\B\2")
Query 3: Source = Folder.Files("F:\MainDir\C\3")

Then I need to move all my files to a new location.
Insted of: F:\MainDir\
I will have the files in:H:\OtherDir\
All the subfolders remains the same...

Is there any easy way to let PowerQuery change all queries sources at once?

Thanks!

PhilC
Posts: 145
Joined: Tue Sep 09, 2014 8:13 am

Re: Change All Queries Source Folders at once

Postby PhilC » Wed Mar 15, 2017 12:09 pm

Could start here:

https://powerpivotpro.com/2015/10/share-and-refresh-power-query-with-local-links/

There are links in that post to other solutions that might be worth reviewing as they might suit your purpose better.

Cheers
Phil

rolo
Posts: 15
Joined: Tue Sep 27, 2016 8:14 am

Re: Change All Queries Source Folders at once

Postby rolo » Wed Mar 15, 2017 10:47 pm

Thanks!


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest