Embed iFrame filtering

[Anonymous]

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.

[andrewtuplin]

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... 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>

[GilbertQ · Accepted solution]

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-porta...

[Anonymous]

Hi Gilbert,

Thanks for your reply!

[GilbertQ]

Awesome, glad that hopefully assist you!