PASSING DYNAMIC PARAMETERS IN URL TO FILTER A POWER BI REPORT

[prakash11440278]

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

[amitchandak]

@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

[prakash11440278]

Hi @amitchandak ,

What i have added the value 7 is a static. That i want to be dynamic and embed the url in cds.

[v-kkf-msft]

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

Get started with a sample 

Control report filters 

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.