Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |