Forum Discussion
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...
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.
PaulDBrown
Community Champion
Community ChampionIt sounds like a task which Power Automate/ Flow is capable of doing with some tweaks. (Not that I a know much about Power Automate/Flow)