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.
Solved! Go to Solution.
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.
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!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.