Need help having two, or more, users execute a power query

Thank you for the help, but it did not quite solve my problem. It may be that I simply do not understand how to set up a dynamic parameter. Following the video I can now easily change the path so one of us can set-up a query and then another team member can edit the path and execute it. But we still need to edit the path. Our user name is in the path and that seems to be the problem. Whatever he is doing in the video does not seem to get me past that problem. When I get to the point of doing the drop down from the parameter icon the choice of parameter is already selected, so I cannot follow him from that point forward.

At this point I would say we are half-way home, but I am still shocked that a query set up to get info from a source file can only be executed by the user that set up the query? In other reading I have done people seem to suggest that anyone opening a file can execute a query that exists, but this does not work for us. We even turned on the feature to auto execute the query when the file is opened but even that only works for the person who created the query. This seems so stupid I keep thinking there has got to be something basic we are missing? Some permission setting?