cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
HulstB Frequent Visitor
Frequent Visitor

Embedded report link doesn't support URL filters.

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Embedded report link doesn't support URL filters.

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>

20.PNG

 

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.

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.

View solution in original post

11 REPLIES 11
Super User
Super User

Re: Embedded report link doesn't support URL filters.

@HulstB What type of embedding are you doing? Publish to web, embed in app, embed in SharePoint?


Near SE WI? Join our PUG Milwaukee Brew City PUG
HulstB Frequent Visitor
Frequent Visitor

Re: Embedded report link doesn't support URL filters.

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

Community Support Team
Community Support Team

Re: Embedded report link doesn't support URL filters.

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.

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 Frequent Visitor
Frequent Visitor

Re: Embedded report link doesn't support URL filters.

I will check it out today...

HulstB Frequent Visitor
Frequent Visitor

Re: Embedded report link doesn't support URL filters.

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?

Community Support Team
Community Support Team

Re: Embedded report link doesn't support URL filters.

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.

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 Frequent Visitor
Frequent Visitor

Re: Embedded report link doesn't support URL filters.

Not working either.

Power BI Team chrisfin
Power BI Team

Re: Embedded report link doesn't support URL filters.

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.

HulstB Frequent Visitor
Frequent Visitor

Re: Embedded report link doesn't support URL filters.

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,405)