Forum Discussion

jrivera43's avatar
jrivera43
Frequent Visitor
5 years ago
Solved

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)

  • Anonymous's avatar
    Anonymous
    5 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

  • Anonymous's avatar
    Anonymous
    Not 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

  • Anonymous's avatar
    Anonymous
    Not applicable

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

    --Nate