Forum Discussion
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...
Thanks Greg_Deckler., sorry if i am not clear
I am trying to read data from a folder as Data source. Assume folder contains 10 files If i read the latest modified file (Top 1 row) this works perfect.
My question was if i need to show the user a list of file names in this folder (10 names), so they can choose which file they want to analyse?
I hope this will be clear? Is there any clean way to do the user input on folder?
Cheers
Anonymous , Not sure I got it . but you have Folder.Files, that will return you table of files
https://docs.microsoft.com/en-us/powerquery-m/folder-files
also refer : https://radacad.com/power-bi-get-data-from-multiple-files-in-a-folder-on-onedrive-for-business-no-gateway-needed