Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power query logic to pick the current year folder

Hi Power BI aficionados   So we have a bunch of Power BI reports whose sources are yearly folders maintained on our corporate network. At the end every year, we need to repoint the folder to the pr...
Need Help
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    This can be achieve by the use of parameters check the video below with a full explanation, you don't need to create an excel spreadsheet with the path information but you can use an alternate version by doing the following code in the source:

     

    "C:\folder\folder" & Parameter_Name & "\Folder\Folder\"

     

     

     

     

    Then you just need to choose the parameter to adjust your PBIX file.

     

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

This can be achieve by the use of parameters check the video below with a full explanation, you don't need to create an excel spreadsheet with the path information but you can use an alternate version by doing the following code in the source:

 

"C:\folder\folder" & Parameter_Name & "\Folder\Folder\"

 

 

 

 

Then you just need to choose the parameter to adjust your PBIX file.