Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team,
How to pass dynamic parameters in report url. I have cds parameters in backend, that i want to use in report url as a dynamic. How we can acheive this? Thanks in advance.
Example:
Our report URL is: https://app.powerbi.com/groups/me/reports/02ff8888-a5fd-4dc7-c9dabf5ca0a5/ReportSection.
Now let’s add the filters. To do this, we append to our report URL: ?filter=query/field eq ‘data to filter on’
For example, let’s say we want our report to only show data for AccountId 7. Our query would look like:
https://app.powerbi.com/groups/me/reports/02ff8888-a5fd-4dc7-c9dabf5ca0a5/ReportSection?filter=Accounts/AccountId eq 7
@prakash11440278 , The way you described is correct. What is the challenge?
You can pass these parameters from your portal
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
Hi @amitchandak ,
What i have added the value 7 is a static. That i want to be dynamic and embed the url in cds.
Hi @prakash11440278 ,
Do you mean url filter on embed report? If this is a case, current it still not support dynamic filter parameter.
Reference link:
Filter a report with a URL query string parameter
I think RLS or Measure will suitable for your requirement.
https://www.kasperonbi.com/creating-a-hyperlink-with-filters-through-dax/
Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Docs
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |