Automate linking file folders monthly in power query

Hello,

I am not having much luck finding a way to automate linking folders each month. I am looking to find a way to make it go fast.



The files have 4 sheets that I have to relink each month to the current months folders. Is there a way to automate that?

Here is what I am currently doing:

PQ editor --> Source --> right click --> change folder path there to new months folder data. I then have to repeat this step for all 4 sheets within the file. That is the part I am looking to automate.

Step 1.PNG


the other options I have used in the PQ editor is just going to new source and adding the folder path that way, but it is the same manual process.

new source.PNG

Thanks!

I found a solution that works. I am just going into edit on the PQ editor, then to source and updating the file path their for each tab. It works good and is faster that way.