Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |