Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Folder as parameter

Hi,   I have a requirement where i want to read data from a folder location. This folder has 10 excel files and i want to show these 10 as a filter parameter for a user to choose and my visuals sh...
Need Help
Tips and Tricks
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

ImkeF edhans , how do you preserve the Source.Name field in a Folder query so that it shows up as a column in the final table? Thanks.

edhans's avatar
edhans
Community Champion
5 years ago

Anonymous - to preserve any columns after you've done a combine operation, go back to the automatically generated Remove Other Columns1 step, hit the gear icon, and check what you want to keep. I think the August 2020 version of Power BI Desktop does this automatically for you (I just tested) but I know this has not always been the case, and it may depend on the types of files (text, Excel) and where you are combining from (OneDrive, local folder, SharePoint Library, DataLake, etc.)

 

You can see that Folder Path is  there for selection as well if you want it.

 

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    edhans - Thanks, for some reason I could not track that down!! Anonymous does this get you where you need to be?