Dynamically Change Connection String per User

[jrivera43]

Hi everyone, 

I'm wondering if anyone can help me with this. Within my organization, we have multiple pbix files saved on OneDrive. Each data source has the original user's name in the connection string in Power Query. Is there any way that we can dynamically change the user name to update to the current user who is working with the file? It becomes a problem when we want to be able to refresh each other's files saved to OneDrive. Any help would be appreciated.

Example:

Source = Excel.Workbook(File.Contents("C:\User Name I want to dynamically update\Path\File.xlsx"), null, true)

[watkinnc]

Pretty slick, yes? This is one of my greatest hits--could you please mark it as the answer?

--Nate

[watkinnc · Accepted solution]

You might be able to make a variable by querying the C:\Users folder, and if there are multiple users, filter to the most recently modified user.

--Nate

[jrivera43]

This worked!! Thanks!

Javier