Dynamic File Path

Hi arosenberg ,

You can replace the Client part of your connection path with a parameter, and connect to files under different paths by selecting a different Client in the parameter:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi arosenberg, 

1.) create dropdown list in Excel:

2.) Create Named Range I choose "SelClient" and send it to PowerQuery:

3.) In Power Query right click inside the cell and choose Drill Down

4.) Create new query from FOLDER and edit address like this: