Forum Discussion
Dynamically Change Connection String per User
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)
- Anonymous5 years ago
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
3 Replies
- AnonymousNot applicable
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
- jrivera43Frequent Visitor
This worked!! Thanks!
Javier
- AnonymousNot applicable
Pretty slick, yes? This is one of my greatest hits--could you please mark it as the answer?
--Nate