dynamic url from a service folder

[Avivek]

I am trying to create a dynamic url from a local service folder which kinds of read like-

 

Files folder has files as shown below:

 

These folders have details for their country for corresponding order id's.

My requirement is to create a hyperlink for the order id's such that if i click that order id it should take me to the required DO folder and download the DO details for that order id in pdf.

All these files are already in pdf format, so my only concern is to create the dyanmic hyperlink. Can someone please help me with it.

[v-yiruan-msft · Accepted solution]

Hi  @Avivek ,

If I understand correctly, you would like to connect to the folders in virtual network dynamically. You can refer the following links to get it:

Using parameter table:

How to pass Dynamic Date Parameter values into Source Connection in Power Query to extract Data 

 Parameterize your data source!

Power BI – Using Parameters for Flat File / CSV / Excel Sources

Best Regards