Forum Discussion
cheryl-lee33
Helper I
Helper IHow to dynamically change the url of the source data based on the user selection?
Hi, I need to build a PBI report with source Excel files stored on the specific web site. Ideally, I would like to allow the users to choose which Excel file that they want to use. As the web s...
lbendlin
Super User
Super UserI don't think that is possible (although Power Query allows dynamic M parameters Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs )
What you can do is load all Excel files into Power BI at the same time and then let the user filter by file name via slicer.