Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
HulstB
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

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

12 REPLIES 12

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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.

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

HulstB
Frequent Visitor

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.

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>

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.

Ok, now it is clear.

Thanks.

Anonymous
Not applicable

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'

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors