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.
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.