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.
Embedded report link doesn't support URL filters.
Could you add this as new feature?
Or is it actually a bug since it seems to work with the normal non-embedded link.
Solved! Go to Solution.
Hi @HulstB ,
Based on this document, The value provided in the pageName setting corresponds to the end of the report URL when viewing a report in the Power BI Service.
We tested it under the Secure Embed Code in Power BI Service and the parameters works fine.
<iframe width="720" height="640" src="https://app.powerbi.com/reportEmbed?reportId=[ReportID]&autoAuth=true&ctid=[ITID]&config=[Config]&pageName=ReportSectionfb03c940d50018e49203&filter=Budget/Brand eq 'Contoso'" frameborder="0" allowFullScreen="true"></iframe>
If there is not what you want, We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@HulstB What type of embedding are you doing? Publish to web, embed in app, embed in SharePoint?
The use case is: Embedding powerbi report snippets onto a webpage.
Embedded works since there is no problem with the x-frame-options = deny when using own report into an iframe....
iframe compatible query parameters work
embedded yes no
normal link no yes
Hi @HulstB ,
Based on this documents, The embed URL supports several input settings that help you customize your user’s experiences. If you’re using the HTML snippet provided, make sure you update the URL in the iFrame’s src setting.
We test by following code.
<iframe width="1140" height="541.25" src="https://app.powerbi.com/reportEmbed?reportId=[reportID]&autoAuth=true&ctid=[ctid]&filter=Budget/Brand eq 'Contoso'" frameborder="0" allowFullScreen="true"></iframe>
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I will check it out today...
It gives me the same front page of the report no matter what pageName and filter is used.
In the comments under the article it has:
"This capability does not support report server reports embedding."
Maybe @lukaszp knows why?
Hi @HulstB ,
If you are embedding a Power BI Report Server report using an iFrame, based on this similar thread, could you please try to append "&filter parameter" after the ?rs:embed=true like following?
http://myserver/reports/powerbi/Sales?rs:embed=true&filter=table/field eq 'value'
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not working either.
Can you contact CSS so we can investigate this further? It's unclear what exactly isn't working from this thread, and Power BI Report Server embedding does support filter values for Power BI reports in the pattern described here, so not sure what the specific issue is.
CSS = Support for PowerBI?
The problem is that there is no combination of parameters that works over https to get a embedded page from a powerbi report with filter query and pageName parameters.
A simple report with filter on "orderitem" and "Page1" + "Page2" is not accessible as embed link.
https://app.powerbi.com/reportEmbed?reportId=[reportID]&autoAuth=true&ctid=[ctid]&filter=Orders/Orderitem eq '12345'"&pageName=Page1
https://app.powerbi.com/reportEmbed?reportId=[reportID]&autoAuth=true&ctid=[ctid]&filter=Orders/Orderitem eq '12345'"&pageName=Page2
Hi @HulstB ,
Based on this document, The value provided in the pageName setting corresponds to the end of the report URL when viewing a report in the Power BI Service.
We tested it under the Secure Embed Code in Power BI Service and the parameters works fine.
<iframe width="720" height="640" src="https://app.powerbi.com/reportEmbed?reportId=[ReportID]&autoAuth=true&ctid=[ITID]&config=[Config]&pageName=ReportSectionfb03c940d50018e49203&filter=Budget/Brand eq 'Contoso'" frameborder="0" allowFullScreen="true"></iframe>
If there is not what you want, We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ok, now it is clear.
Thanks.
Hi HulstB,
Have you finally resolved it?
Got exact the same issue. Filter passed to url are not applied.
In my case the url look like this:
https://app.powerbi.com/reportEmbed?reportId=XXXf&autoAuth=true&pageName=ReportSectione776ca6d6b28d8e363c4&filter='Main Table'/'Sales Level 2' eq 'AMERICAS_SP'
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.