Hi everyone,
I've a model with hundreads of file taked froma folder.
Frequently I have to change the folder path of PowerQuery to choose a different folder.

My questions are two:

1- is it possible to set the new folder path from Excel Worksheet in order to avoid to enter every time into Power Query enviroment to change it? Could be so usefull for me to simplify this task with a cell destinited to the folder path.

2- when I use the wizard of Power Query to create a connection with a folder it creates the query I would plus a groups of other query in wich I'm not able to find some sort of value for me, worst if I have to change the folder path I have to change it in both query in orther to have Power Query without errors... can I delete in some way this group of folder? What is the value of this automatic steps?