Update source location for all files together

[itsmeanuj]

Hi, We have a performance dashboard that includes data from 25 different CSV files placed in a single folder. This folder changes every quarter and I need to update the folder location in all the 25 files every quarter. It is a very cumbersome and error-prone task. Is there a way where I can update the location in just one place and it automatically gets updated for all the input files.

Thanks, Anuj

[v-kelly-msft]

Hi @itsmeanuj ，

Try "Combine files",below is the reference.

https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mwegener]

Hi @itsmeanuj ,

check this out...

https://powerpivotpro.com/2017/05/power-query-magic-part-1-always-good-references/

... and this ...

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters