Power Query change source file

[aam1932]

Hai,

I have 2 question.

1) Any possible that I can change the source file by selecting the cell contain the file name without editing the query editor. Example , if I want to change the file name to 04 to 05, just type at any cell in excel and the query will change

2) I have few file to merge and append, how I can change the source file at 1 time for all the file. Example, I want to recon for month of Apr 2016, so the source file should change the file only for april 2016.

Thank you

 

[Matt Allington]

You could set up a parameter query. I wrote a blog that uses paramete queries last year. Take a read and it may give you some insight. Share and Refresh Power Query with Local Links - PowerPivotPro

 

[peejay]

Ken Puls has posted an article on feeding parameters to a Power Query. This should help.

See here. Pass Parameters to SQL Queries - The Ken Puls (Excelguru) BlogThe Ken Puls (Excelguru) Blog