Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic update of filepath

I import a folder of Excel files into Power BI using something similar to the below   let Source = Folder.Files("C:\Users\MyUsername\Box\MyFolder"), #"Filtered Rows" = Table.SelectRows(Source, each...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have been able to get the system username into a table through an R script, but how can I use this in the folderpath of my source?

 

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    It seems you have different files in a folder, each file belong to a different user,

    user a will update file a into power bi, user b will update file b into power bi, right?

    If so, please create dynamic parameter to fetch different data source file.

    Reference:

    Power BI Desktop Query Parameters, Part 1

    Dynamic Data Source based on parameter

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.