Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
rtran
Helper I
Helper I

Custom URL with parameters

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!

1 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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

6 REPLIES 6
GilbertQ
Super User
Super User

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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? 

 

 

 

 

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. 

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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!

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors