Custom URL with parameters

[rtran]

Hello, 

I have been following this guide: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters and have successfully filtered my report through this. Is it possible for this to be done dynamically through a variable? 

Example: ?filter=Table/Column eq '123' 

Can the filtered value (123) be replaced with a variable instead? So the variable will store the value dynamically and filter the report accordingly. 

Ex. ?filter=Table/Column eq client

Where client is the variable and can equal any number depending on the parameter passed to it. 

Much appreciated!

[GilbertQ]

Hi there

This could be done within a report using a table matrix and a DAX measure which would get the value of the row and build URL dynamically.

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables

[rtran]

Hi Gilbert,

Unfortunately, that isn't quite what I am looking for. 

In my case, we are embedding the report that allows users to view information based on clients. The idea is to create one report that has all the clients, but it will filter the report based on what client the user is viewing. For example, I am looking at Client 123, then the report will show and filter all the data based on Client 123. If I want to view Client 321 instead, that will change the link accordingly and filter for Client 321. 

Typically, the ending of the URL would be ?filter=Table/Column eq '123' or ?filter=Table/Column eq '321' but we want to store the client ID as a variable in which we pass in the value so that we can create one link and not need to create X amount of links for every client we have. Is this possible? 

[rtran]

For more clarification, the report is not being embedded into another PowerBI report but an external service -- which the external service would provide the client ID as the parameter to be passed into the URL link. 

[GilbertQ · Accepted solution]

Hi there

Thanks for your details.

Could the external service then not pass through the clientID as part of the URL when the user clicks on it?

[rtran]

Hi Gilbert, 

Turns out I was over complicating it! I was just able to confirm that the external service will pass the client ID through and filter accordingly. 

Thank you for all your help!

[GilbertQ]

That is great, sometimes it can be easier than initially thought!