Forum Discussion
Retain all info on table and data when source folder name is changed
- 6 years ago
Hello Anonymous
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
Hello Anonymous
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
Thank you, Jimmy! It works now!