Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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>
Hi Gilbert,
Thanks for your reply!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.