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

Question

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.

Append &ctid=ctid to the end of the query string so that it looks like https://msit.powerbi.com/groups/xxx/reports/xxx/ReportSectioncxxx?filter=RequestDetails/Number eq 'xxxx''&ctid=ctid. You can find the explanation here: Filter a report using query string parameters in the URL - Microsoft — Dennis VW
– Dennis VW, Commented Apr 18, 2020 at 4:23
still the same error. is it needed to add "reportEmbed" in the URL? base URL without filters works have that text. — user2038538
– user2038538, Commented Apr 18, 2020 at 6:41

user2038538 · Accepted Answer · 2020-04-20 06:21:15Z

1

Working Embeded filter URL

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

answered Apr 20, 2020 at 6:21

user2038538

2316 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related