Forum Discussion
Sudharsanan
Helper III
Helper IIIDynamic 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.
jennratten
Super User
Super UserThis 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.