Forum Discussion
Passing dynamic filter values through URL Filters in embedded report
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
1 Reply
Hi Rida
1.You can build experiences using basic HTML and JavaScript.
You can refer to the following link.
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.
