How to dynamically change the url of the source data based on the user selection?

[cheryl-lee33]

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 site address involves some parts of texts that have no particular patterns, hence I please to have the web site stored in an Excel file, and the file will be used as a slicer for the user to choose.  The format is simply as below:

The report column will be used for the users to select from the slicer, and the URL will be used as the data source to locate the Excel file.  

I tried using parameter (without the Excel table shown above) to update the web site, and the url is updated.  However, the process of entering the web addresses is not ideal for the users to enter. 

Can anyone help and let me know what processes I should have to use the url stored in the Excel file and change the source files used in the PBI report?

Thanks in advance for your help!

[lbendlin]

I 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.