Forum Discussion
Copying a project template folder with Power Query connections
- Jun 02, 2022
JanetteCunningham Perhaps the blog post in the link below is useful.
https://www.excelguru.ca/blog/2014/11/26/building-a-parameter-table-for-power-query/
It describes, among other things, how you can set-up PQ so that it connects to files in a particular folder. For instance, the folder where the active workbook is saved.
JanetteCunningham Perhaps the blog post in the link below is useful.
https://www.excelguru.ca/blog/2014/11/26/building-a-parameter-table-for-power-query/
It describes, among other things, how you can set-up PQ so that it connects to files in a particular folder. For instance, the folder where the active workbook is saved.
Riny_van_Eekelen While I was hoping for a solution that was automated without the need for user input, I have a feeling this may be the only viable solution without using Power Automate. Thank you so much!