Dynamic filtering in Power BI Embedded URL

raasrini1 — Tue, 20 Jun 2017 14:57:21 GMT

Hi,

Is there a way to add the dynamic filtering capability to a power bi iframe URL ? My need is I have a embedded power bi report containing a table and when I click open the URLs from the table, it opens another Published to Web or embedded report with the filtered value from the table . eg: Country eq 'Selected Value'. I seen the example of oDataFilter option in URL but that dont seem to work for me, as well checked the cases where we can add the Filter in the javascripts to do the preselection. But , what I need is the ability to filter dynamically and basically the filters are to passed through the URLs.

Any help is appreciated.

Regards,

Raaju S R

Re: Dynamic filtering in Power BI Embedded URL

Eric_Zhang — Wed, 21 Jun 2017 09:29:35 GMT

@raasrini1 wrote:

Hi,

Is there a way to add the dynamic filtering capability to a power bi iframe URL ? My need is I have a embedded power bi report containing a table and when I click open the URLs from the table, it opens another Published to Web or embedded report with the filtered value from the table . eg: Country eq 'Selected Value'. I seen the example of oDataFilter option in URL but that dont seem to work for me, as well checked the cases where we can add the Filter in the javascripts to do the preselection. But , what I need is the ability to filter dynamically and basically the filters are to passed through the URLs.

Any help is appreciated.

Regards,

Raaju S R

@raasrini1

AKAIK, there's no completed solution for your requirement.

However you can implement something similar in a embedded report via Power BI Javascript API(see Handling Events--dataSelected).

            report.on("dataSelected", function (event) {
                var data = event.detail;
                console.log(data);
            });

Another promising approach(coming in future) you'd expect is drilling though pages, see introduction in this video(starts at 59:59).

topic Re: Dynamic filtering in Power BI Embedded URL in Developer

Dynamic filtering in Power BI Embedded URL

Re: Dynamic filtering in Power BI Embedded URL