Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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 r...
  • Jimmy801's avatar
    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