SSRS migration SP 2013 to SP 2019

shashank 131

We have on-prem SP 2013 environment (with SQL 2012) which is running hundreds of SSRS reports. We are planning to migrate to on-prem SP 2019 (with SQL 2016) and it says SP 2019 doesn't have SSRS feature now. In this case, how do we get to see our existing SSRS reports in SP 2019

Accepted answer

KoprowskiT 236 Reputation points

2021-02-15T18:06:16.447+00:00
@shashank There are no migration steps for SSRS from SP2013 to SP2019, as SSRS in SP 2019 not exist at all. The way you can use is to migrate to PowerBI, which in most cases mean you have to rewrite reports using PowerBI. Which all you:
1st - making your report better and more usable to clients
2nd - reduce the number of reports (as users will be able to drill-in-to existing reports
3rd - manage distribution (sharing) reports much more effectively than with SSRS

Links which could help:

Get more from your data with analytics solutions | https://www.microsoft.com/en-gb/resilience/business-insights-analytics-solutions?ef_id=83653195475414e0084051bff0df75fa:G:s&OCID=AID2100620_SEM_83653195475414e0084051bff0df75fa:G:s&msclkid=83653195475414e0084051bff0df75fa

Migrate SQL Server Reporting Services reports to Power BI | https://learn.microsoft.com/en-us/power-bi/guidance/migrate-ssrs-reports-to-power-bi
Please sign in to rate this answer.

1 person found this answer helpful.
shashank 131 Reputation points

2021-02-17T11:21:21.187+00:00

we have hundreds of SSRS reports.. it will require hundreds of power bi license. We are thinking to use the workaround by copying the report from SP into SQL based hosting (and use report viewer in SP to view them). Question is can we simply take SP integrated SSRS report and host it in SQL server based SSRS or will it need the redevelopment of the reports?
NOTE: We will use SQL 2016 with SP 2019

KoprowskiT 236 Reputation points

2021-02-17T11:31:31.377+00:00

Not necessary. Licensing of PowerBI reports depends on the way of the utilisation of those reports. You can check good post from UK's Microsoft Partner her: https://blog.coeo.com/power-bi-licensing-deployment-options

And [my very private comment] being SharePoint/SQLServer/Report administrator you should be up to date with changes. I teach on my courses about those changes since 2016 (so for over five years) this is not new information or announcements.
Sign in to comment

2 additional answers

Lukas Yu -MSFT 5,816 Reputation points

2021-02-15T09:54:54.927+00:00

Hi,

Sharepoint integrated SSRS is no more supported with newest release of both apps.

The newest we could get in SSRS 2016 with SharePoint 2016. I am afraid there is no work around here and we have to go other way.

You could see the SSRS and SharePoint combination here : Supported combinations

Regards,
Lukas
Please sign in to rate this answer.
shashank 131 Reputation points

2021-02-15T10:02:51.387+00:00

What do we do in this case. How can we see our reports in SP 2019? Workarounds??

KoprowskiT 236 Reputation points

2021-02-15T16:30:39.297+00:00

@shashank as SSRS is a depreciated product, the only way is to start using PowerBI. In many cases, this platform will bring new quality for your reports and easy integration with many (not only) Microsoft product.

shashank 131 Reputation points

2021-02-15T17:37:28.967+00:00

So how can we see our existing reports from SP 2013 to 2019..I am getting general answers but looking exact steps to migrate ssrs from sp2013 to 2019

Trevor Seward 11,691 Reputation points

2021-02-15T19:18:26.38+00:00

There are zero migration paths. You need to rebuild your reports in SSRS Native mode, Power BI Server, or Power BI service. There's no method to convert between SSRS SharePoint and Native mode reports. There is no method to upgrade to SharePoint 2019 with SSRS.

You're in for a lot of manual work, unfortunately.

Lukas Yu -MSFT 5,816 Reputation points

2021-02-16T01:43:38.093+00:00

Like trevorseward and KoprowskiT said, in this case , we need to rebuild the report in SSRS native mode. SP 2019 can not be integrated with SSRS.

shashank 131 Reputation points

2021-02-16T05:39:44.757+00:00

Hi Trevor..I just found we can install SSRS in our SP 2019 DB server (SQL 2016) and use report viewer webpart in SP site to display the reports. Can you shed some light if it can be done and what should be the process to do it?

Trevor Seward 11,691 Reputation points

2021-02-16T15:44:08.78+00:00

Follow the SSRS documentation. You should not install SSRS with any other components, especially on a SQL Server. Yes, you can do that - AFTER converting all your reports manually to SSRS Native reports.

You're unfortunately not going to get out of this manual process if you want to upgrade to SharePoint 2019.

shashank 131 Reputation points

2021-02-17T04:50:29.123+00:00

Hi Trevor. Thanks. I am a little confused. As we have been doing till now where we configure SSRS in our SP SQL server and on our SP servers, can we not do the same here? Something like this https://www.enjoysharepoint.com/configure-ssrs-in-sharepoint/
And then use the report viewer webpart to view the SSRS report.
Could you please elaborate how I can get through this in SP 2019 to see my existing reports there. Or any article that mentions the steps.
NOTE: In SP 2019 we will be using SQL 2016 server

shashank 131 Reputation points

2021-02-17T11:14:34.903+00:00

question is can we simply take SP integrated SSRS report and host it in SQL server based SSRS or will it need the redevelopment of the reports

Trevor Seward 11,691 Reputation points

2021-02-17T16:13:39.253+00:00

You shouldn't put SSRS on SQL Servers; there is memory contention to deal with as well as reduced security. SSRS should be on dedicated servers, if possible.

You will need to manually recreate your reports in SSRS Native mode.
Sign in to comment
KoprowskiT 236 Reputation points

2021-02-17T11:24:45.933+00:00

@shashank well, mate. We explained it very well. Not only once. You have to rebuild every report from scratch. SSRS is finally removed as a feature from SQL Server and SharePoint Server. There is no possibility to have it a- as before - in SharePoint 2019. You have to rebuild it into PowerBI.

The article you mentioned is not relevant as they explain implementation on SQL Server 2012 and SharePoint 2013. As well there is a lot of errors and bad practices in this article (wrong location, wrong installation, putting together SQL Engine and SSRS in one instance and more). This is an example of the very, very bad practice.

There are some examples of how you can configure SharePoint 2019 with SSRS 2017 BUT - and this is the citation from the blog post:
"Officially SSRS Integrated mode is deprecated in SQL Server 2017 and SharePoint 2019, Now It is not a part of the SQL Server 2017. However, organizations could continue to use SSRS versions 2017 in SharePoint 2019. This is not supported in SharePoint 2019, which means that integrated mode isn’t an option at all with SharePoint 2019.
But the good news is, there is some workaround to integrate SSRS 2017 with SharePoint 2019 using the report viewer web part."

So if you will go this way, this solution is not supported by Microsoft. Which means - in case of a disaster of problem Microsoft support will not help you, because the solution is not supported.
Please sign in to rate this answer.
shashank 131 Reputation points

2021-02-17T13:04:58.45+00:00

Thank you and apologies for this repeated questions. So many Power BI License would not be possible..Could you just help me on the steps for the report viewer workaround. I mean how we can achieve to view our reports in 2019 using this workaround

Trevor Seward 11,691 Reputation points

2021-02-17T16:20:35.453+00:00

Information about the webpart is at https://learn.microsoft.com/en-us/sql/reporting-services/report-server-sharepoint/report-viewer-web-part-sharepoint-site?view=sql-server-ver15.

shashank 131 Reputation points

2021-02-17T16:51:32.513+00:00

I cannot thank you guys enough. If you can understand my confusion, I am actually looking for the steps on how to view my SP 2013 SSRS reports in my SP2019 environment using the Report Viewer webpart workaround. If you have it by any chance, it would be a great help. Even if you don't, I am going to accept your answer and thank you guys again for your kind answers.
NOTE: We'll be using SQL 2016 with SP 2019

KoprowskiT 236 Reputation points

2021-02-17T17:04:17.773+00:00

That was the only a link for the post. As example. Any licensing discussion is by default more complex than just saying we cannot use this, we cannot use that.

KoprowskiT 236 Reputation points

2021-02-17T17:07:31.453+00:00

You have several links posted above. As well you can find it relatively easy in Microsoft Learn. I cannot post a link for blog, but if you copy & paste the citation into bing search. Then you will find the blog easily.

Trevor Seward 11,691 Reputation points

2021-02-17T17:30:35.753+00:00

You can't use the Report Viewer webpart to view reports from a 2013 farm. It only works against an SSRS Native mode instance.

Unfortunately while you're attempting to find workarounds, you're going to have to put in the hard work of recreating your reports should you wish to move to 2019. I know you keep asking for alternatives, but there are no alternatives besides keeping your 2013 farm intact until you do decide to move to SSRS Native or another solution like Power BI.

I know this is hard to digest, but you really don't have any other options no matter how many times you ask for alternatives.

KoprowskiT 236 Reputation points

2021-02-17T17:42:34.043+00:00

And you can be nicely surprised when you discover that 40 or 60 per cent of your reports are irrelevant, old and not important, and you can simply get them off your system. I've seen this scenario couple of times.
Sign in to comment

Share via

SSRS migration SP 2013 to SP 2019

2 additional answers