Forum Discussion
Solved
Dynamic Source path
Hi All, Can someone help me in setting up dynamic source path in power query?. My data will be placed with different folder name. Appreciate your support!!
This is how you can use parameters to make a source file name and path dynamic:
Create 2 parameters - one for the file name and one for the file path.
Replace the hard-coded file name and path with the parameters. In this example I am connecting to an Excel file.
Hi Sudharsanan ,
Here's a way to set up dynamic file path by creating parameters, please kindly refer to
Create Dynamic File Path in Power Query - Goodly
Changing File Location Using A SQL Query Parameter In Power BI | Enterprise DNA
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.