Forum Discussion
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.
3 Replies
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.
hello, with all due respect this is not dynamic as you are stating "hard-coded" filename. As far as i know there is no direct way to implement dynamic links in power bi.
On the contrary.. in excel power query there is a solution which might be applied in Power BI.Create an excel file named parameters and save it at the same place as the pbix file;
Name cell A1 : folderPath
type the following formula in that cell
=LEFT(CELL("filename";A1);FIND("[";CELL("filename";A1))-1)That formula gets the excel file path 🙂 which is dynamic as it updates whenever you move the excel file from one folder to another.
In Power BI, connect the excel file and read the content of the cell named folderPath --> your dynamic path is now active
