Forum Discussion
Embed iFrame filtering
Hi,
I have successfully used this link to create filtered URLs for embedded reports:
https://docs.microsoft.com/en-us/power-bi/service-url-filters
But how do I edit the iFrame code to filter reports? The URL filtering logic doesn't seem to work.
- Hi there
I think that you possibly cannot do this via an iFrame
Have you had a look at the secure embed?
https://powerbi.microsoft.com/en-us/blog/easily-embed-secure-power-bi-reports-in-your-internal-portals-or-websites/
4 Replies
- Hi there
I think that you possibly cannot do this via an iFrame
Have you had a look at the secure embed?
https://powerbi.microsoft.com/en-us/blog/easily-embed-secure-power-bi-reports-in-your-internal-portals-or-websites/- Awesome, glad that hopefully assist you!
For Embedding an iFrame, I found it matters where in the query string you insert the filter. If I inserted the filter at the end of the querystring (as the documentation suggests) I wasn't able to authenticate. If however, I added the filter directly after the ? and before the ReportId, it worked.
This DOES NOT work (cannot authenticate)
<iframe title="Your Report Title" width="1140" height="541.25" src="https://app.powerbi.com/reportEmbed?reportId=55aa2cd4-aaa-bbb-ccc&autoAuth=true&ctid=cabcdefg&filter=SomeTable/SomeColumn eq 'MY_VALUE_TO_FILTER'" frameborder="0" allowFullScreen="true"></iframe>
Example. This works:
<iframe title="Your Report Title" width="1140" height="541.25" src="https://app.powerbi.com/reportEmbed?filter=SomeTable/SomeColumn eq 'MY_VALUE_TO_FILTER'&reportId=55aa2cd4-aaa-bbb-ccc&autoAuth=true&ctid=cabcdefg" frameborder="0" allowFullScreen="true"></iframe>
