Search code examples
iframepowerbiangular7powerbi-embeddedpower-bi-report-server

How to display Power BI reports with filters in iframe in angular application

I am trying to display the PowerBi report with filters in Iframe in my angular application. I successfully display below embedded URL in the iframe without filters.

<iframe src="https://msit.powerbi.com/reportEmbed?reportId=xxx&autoAuth=true&ctid=xx&config=xxx"></iframe>

here I need to filter the reports against some RequestId and then display it in the iframe.

filtered URL https://msit.powerbi.com/groups/xxx/reports/xxx/ReportSectioncxxx?filter=RequestDetails/Number eq 'xxxx'

getting below error when I tried this in iframe:

Refused to display 'URL' in a frame because it set 'X-Frame-Options' to 'deny'.

How to convert this filtered URL as embed URL to display in an iframe.

Solution

  • Working Embeded filter URL

    https://msit.powerbi.com/reportEmbed?reportId=xxx&autoAuth=true&filter=RequestDetails/SRNumber eq 'xxx'&ctid=xxx