Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 present year in order for the report to render current year information. For example, I've had to manually change the source folder from 2019 to 2020 once we transitioned into 2020. Is there a way we can automate this? In other words, is it possible via power query for the source to automatically point to the current year folder without me having to do the manual step? Let me know if you'd like more details. Thanks in advance for your help.
Solved! Go to Solution.
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsProud to be a Super User!
Paul on Linkedin.
You can't do this directly....:) but here is a link to a RADCAD post that gives step by step instructions for doing it in M in the query editor.
https://radacad.com/fetch-files-andor-folders-with-filtering-and-masking-power-query
I'm a personal Power Bi Trainer I learn something every time I answer a question
The Golden Rules for Power BI
Help when you know. Ask when you don't!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |