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

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

andlin11 — Wed, 29 Jan 2020 15:19:41 GMT

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:

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

ForcaTaico — Fri, 31 Jan 2020 08:13:50 GMT

Hi andlin11

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

Regards Taico

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

lader — Fri, 31 Jan 2020 21:03:57 GMT

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

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

Anonymous — Mon, 03 Feb 2020 11:59:09 GMT

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?

Andreas

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

lestagek — Mon, 03 Feb 2020 13:09:27 GMT

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

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.

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

Anonymous — Mon, 03 Feb 2020 13:55:23 GMT

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

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

lader — Mon, 03 Feb 2020 14:09:46 GMT

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-reporting-services?view=sql-server-ver15

lestagek Thanks!

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

Anonymous — Mon, 03 Feb 2020 14:36:55 GMT

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

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

ForcaTaico — Mon, 03 Feb 2020 19:46:58 GMT

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

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

andlin11 — Tue, 04 Feb 2020 09:22:44 GMT

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

Thank you for all the input in this tread
Regards Andreas

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

PBIUser135 — Fri, 07 Feb 2020 13:28:10 GMT

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.

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

mjpereira — Wed, 19 Feb 2020 20:06:32 GMT

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

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

andlin11 — Wed, 19 Feb 2020 20:15:57 GMT

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

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

Anonymous — Thu, 20 Feb 2020 14:35:41 GMT

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

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

d_gosbell — Wed, 04 Mar 2020 02:23:43 GMT

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

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

PBIUser135 — Wed, 04 Mar 2020 18:23:35 GMT

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

😍😘💋🍆