Passing dynamic filter values through URL Filters in embedded report

[Rida]

Hi!

I have an embedded power BI report, which is embedded in a different web tool. That tool has 3 filter values which need to be passed into the report and then the report should open reflecting the filtered data.

I was able to embed the report in the tool and that's opening just fine. But I'm not able to pass the filter values that the user would select.

I know that I'm supposed to use my embedded report URL from iFrame, add &filter=<table_name>/<column_name> eq '<value>'

But what should I put in place of <value> so that the user would get result for A, B, or C depending on their selection?

Any help would be highly appreciated. For reference, this was achieved using Tableau like this: <Tableau embedded report URL>&Parameters.Instance="+       this.instance+"&Parameters.Pipeline%20Id="+this.pipeline_id+"&Parameters.Propensity="+this.propensity+"#1"

where,  Instance, Pipeline, and Propensity are my parameters.

Thanks in Advance!

Rida

[Anonymous]

Hi @Rida 

1.You can build experiences using basic HTML and JavaScript.

You can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-embed-secure#filter-report-cont...

Use filters when embedding a report in Power BI embedded analytics | Microsoft Learn.

2.The URL filter has some limitations on embedded report.

•   Embed to Sharepoint doesn't support URL filters.
• Teams doesn't allow specifying a URL.

You can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#embedding-scenarios

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.