Retain all info on table and data when source folder name is changed

[mrbuttons07]

Hello there,

I consolidated multiple excel files (slave files) by folder based. Once everything is done and the connection between the slave files and master file has been established, I have to reedit the entire table formats and input when I change the folder name. Basically, I have to start from scratch when I change the source folder name.

Is it possible to retain every single data, table inputs, formats and applied steps when I change the folder name? I don't know if it's possible to do so but this is one of the conditions I have been investigating when I start this task. 

Thanks!

[Jimmy801 · Accepted solution]

Hello @mrbuttons07 

if you are working in Excel, you could use a table to maintain your folder and use this as input of your folder-query. In Power Bi however you have only the possibility to use a Parameter.

Create a new parameter as Text and call it like "pFolder" as Text and with your folder information like that

when your a creating your query, replace the folderinformation with your parameter pFolder. Once the folder inforamtion changes, just change the parameter and everything is fine

If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy

[mrbuttons07]

Thank you, Jimmy! It works now!