Can an operations dashboard selector filter an embedded Power BI report?

639
1
01-11-2021 07:35 AM
by Anonymous User
Not applicable

I have a power bi report that shows results of various sample measurements by by user-selected location. It has functionality dashboard does not have - It uses the bar/line combo visualization to show results on 2 different y axes - A crucial functionality for comparing measurements with different scales.

I can load the power bi report into the dashboard and the user can access it, but I would like to make the power bi report responsive to dashboard selectors. If I select "Features" type, I can set the power bi report as a target, but it's not working as hoped. I would like the power bi to display results for the location selected by the dashboard selector.

Is this possible?

Thank you,

Randy McGregor

1 Reply
AndresEcheverri
Occasional Contributor

Hi Randy 

I am trying to achieve the same result you are after. I have a Power BI report with several pages, and I would like to filter one of the pages with the value from the selector. 

Power BI allows to filter a report using query string parameters in the URL. See this link. In theory, if you replace the "value" part with the field being used in the category selector you could be filtering the report.

In my case,  I can add the report to the Dashboard and users can visualize the whole report and interact with it (as you did).  The filter using the URL parameters works fine when I embed the URL within a different app (not the Operational Dashboards, I am using ArcGIS Enterprise, not AGOL) . However, when I embed the Power BI report, with the URL parameters included, the report is not rendered within the Dashboard, with the following problem: 

Refused to frame 'https://app.powerbi.com/' because an ancestor violates the following Content Security Policy directive: "frame-ancestors 'self' https://teams.powerbi.com https://teams.microsoft.com https://outlook.office.com https://outlook-sdf.office.com https://outlook.office365.com https://outlook-sdf.office365.com https://www.office.com *.www.office.com".

I haven't tried using a report with a single page.

Andres

0 Kudos