"RS:embed=true" command not working in Sharepoint 2013 when upgrading to PBIRS jan 2020

[andlin11]

Hi!
Our iframed Pbix-reports stopped working after upgrading to Power BI Report Server jan 2020.
After upgrading the iframe command no longer accept "rs:embed:true" when linking to a report. 
If I change to rs:embed=false the report shows up again.

Content editor Web Part:

<iframe width="1320" height="770" src="http://server/reports/reportname?rs:embed=true"></iframe>
Anyone experiencing the same issue after upgrading to PBI RS jan 2020?

[lestagek · Accepted solution]

The CustomHeaders property on the advanced settings of the report server defaults to:

<CustomHeaders>
<Header>
<Name>X-Frame-Options</Name>
<Pattern>(.+)((\/api)|(\/(mobilereport|report|powerbi|excel|pages)\/(.+)(rs:embed=true|rc:toolbar=false)))</Pattern>
<Value>SAMEORIGIN</Value>
</Header>
</CustomHeaders>

I changed it to:

<CustomHeaders><Header><Name>Embed</Name><Pattern>(.+)(/reports/)(.+)(rs:embed=true)</Pattern><Value>True</Value></Header></CustomHeaders>

Embedded reports are working now.

Connect to the report server via SSMS, right click on the server and server properties.  Click on the Advanced option.

[andlin11]

Awesome, thank you @lestagek !
A heads up from MS would have been nice.

Thank you for all the input in this tread
Regards Andreas

[PBIUser135]

Same problem for me, and same solution. MS dropped the ball on this one. A simple heads up would have saved me 3 hours yesterday. 

[mjpereira]

Hello all.

Made this change on my report server and now i get 503 error, service unavailablem and can´t connect via ssms to the reporting server instance to correct. Any help is appreciated, as i´m looking at rebuilding the server...

Regards,

Manuel Pereira

[andlin11]

Hi Manuel,
The ssrs service restarts after changing the property. Is your service up and running?

[Anonymous]

---

@andlin11 wrote:
Hi Manuel,
The ssrs service restarts after changing the property. Is your service up and running?

---

It was. I tried restarting the services, restarting the server, repairing the Report Server installation, checking .config files, what have you. Lost connection to the report server database entirely. Ended up having to create a new report server database, reload all reports, rebuild folder structure, reconfigure security and automatic refresh rules.

So yeah, a fun morning...

[d_gosbell]

Microsoft just released an update that may fix this issue along with a few others

See here for the change log https://docs.microsoft.com/en-us/power-bi/report-server/changelog

And you can download the update from here https://aka.ms/pbireportserver 

[PBIUser135]

My Dude... Thanks for the tip. Applied the update and we're good! 😎

😍😘💋🍆

[ForcaTaico]

Never mind my last post (deleted) I was pointing to production server (sep 2019)...

Thanks for the solution @lestagek worked like a charm!

Would have been nice if MS mentioned it explicitly in the release notes.

Regards Taico

[lader]

Yes! This is the solution. 

You have to change the settings on the custom headers.

More info here: https://docs.microsoft.com/en-us/sql/reporting-services/tools/server-properties-advanced-page-report...

@lestagek Thanks!

[AndreasScholl]

Thanks for your support, unfortunatley I am missing the option in my advanced settings of the report server...

Any clue on that? 

Thank you!
Andreas

[AndreasScholl]

I got it - its within the reporting services properties. Thank you. PRoblem is solved. 

[AndreasScholl]

Hello all,

same here, we used some Iframes within our Intranet (Confluence), all of them are not longer working now.

Is MS working on that or is this no longer supported?

BR

Andreas

[lader]

I have the same issue. The problem seems to be with the embed function and the iframe.

PS: Looking the issue we are having the error Refused to display in a frame because it set 'X-Frame-Options' to 'sameorigin'. This should not happen because we are sending ?rs:embed=true at the end of the URL so the report is embebed. Something changed in the last update. =(

[ForcaTaico]

Hi @andlin11 

I have the same issue with iframe when using  "rs:embed:true". Also on SharePoint 2013.

Regards Taico