Working with Multiple Users in Power Query

How to use a parameter in Power Query in order to allow multiple users to work with the same Excel template (that might pull a CSV / XLS file from a different location).
Also will help if you have a file name that frequently changes, so that you don't have to rewrite your query in order to pick up a new Excel or CSV file!

[@andyycandy91]

Thank you so much! You just saved my life. It just worked well on my power queries and succeeded in sharing with others. 😊

[@rafaelaaguilar2587]

Thank you for this video. I do not think this worked on my power query. I need to give a user access aside from me. Is there a way to do this?

[@lorneneilcampbell]

This will not work with multiple users, it will only work with C/users/Name of user - how do you make a shared file work with a button to refresh that data, using power query, so that you do not have to re-point data source to each user/c/locally sync'd onedrive sharepoint folder and they can just press a button whether user 1 is updating it one day or user 2 is updating it one day - is there a way to make the data source look at "Who is logged in", use their username for the file path ?

[@khalilbadmus144]

This is what I need to know!