Forum Discussion

Anonymous54000's avatar
Anonymous54000
Frequent Visitor
3 years ago
Solved

Allow user to choose files from folder

Hello, I am creating a PBI report and right now data source is a whole folder with all excel files inside. I would like to allow user to choose the files is interested for (loading all files is...
  • christinepayton's avatar
    3 years ago

    When you use the folder connector, it should add a column with the filename when the files are combined. If you just add that to a slicer or the filter pane, it should let them to filter the data by the filename. If you are worried about speed, you could use the query reduction setting for the slicer that makes them select something before the data will load. 

     

    I don't think report-level parameters are something the viewers can interact with, they are more for report creators to easily swap things. Field parameters would work, but they're not necessary here if all you want to filter on is the filename.