Update source location for all files together

Question

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

mwegener · Answer

Hi&nbsp;itsmeanuj&nbsp;,
&nbsp;
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
&nbsp;

v-kelly-msft · Answer

Hi itsmeanuj ，&nbsp;Try "Combine files",below is the reference.https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries&nbsp;Best Regards,KellyDid I answer your question? Mark my post as a solution!

Forum Discussion

Update source location for all files together

2 Replies

Related content

Issue with Using 'Location' and 'Legend' Together in Azure Map Visual After September Update

App not updating

Tool tip Location

Using Import Models and Dataflows Together

Roster by Location