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 everyone, I need to get data from a file which name changes everyday without having to build again the connection in Power BI. For example, today the file's name is 2017-01-20.xlsx, but tomorrow it would be replaced with a new file called 2017-01-21. Is this posible? Thank you very much for your help.
Solved! Go to Solution.
Hi @jafh
You may try to go to Advanced Editor to change the file path as below.
You may also go to Manage Parameters to create parameters for your file name as below. Then add the parameter to the path in Advanced Editor. Finally, you may change the file path by changing the parameters.
Regards,
Cherie
Hi @jafh
You may try to go to Advanced Editor to change the file path as below.
You may also go to Manage Parameters to create parameters for your file name as below. Then add the parameter to the path in Advanced Editor. Finally, you may change the file path by changing the parameters.
Regards,
Cherie
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 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |