Forum Discussion
Custom URL with parameters
- 5 years agoHi 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?
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
- rtran5 years agoHelper I
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?
- rtran5 years agoHelper I
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.
- GilbertQ5 years agoSuper UserHi 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?