SSRS Going Away?

Colin Sachs 40 Reputation points
2024-04-19T19:31:42.4666667+00:00

I was informed by my IT department that the next upgrade they are making to upgrade our SQL server will not be supporting SSRS.

I couldn't find any information to back-up their claim from Microsoft's website, other than that in SQL Server 2022, certain features of SSRS were being depreciated - but nothing that stated that SSRS would no longer be available at all.

Is it or is it not available? And what is the roadmap for development/support for it?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,042 questions
0 comments No comments
{count} votes

Accepted answer
  1. Greg Low 1,970 Reputation points Microsoft Regional Director
    2024-04-20T03:38:46.01+00:00

    It is still available and deprecation has not been notified at all. Note the Microsoft pages on it: https://learn.microsoft.com/en-us/sql/reporting-services/create-deploy-and-manage-mobile-and-paginated-reports?view=sql-server-ver16

    There are still an enormous number of customers using SSRS.

    This is from a while back but still pretty much to the point apart from a few recent changes:

    https://blog.greglow.com/2020/02/11/opinion-sql-server-reporting-services-the-reports-of-my-death/

    Paginated reports in Power BI are a partial replacement for SSRS in some environments. But there are many environments where it's still the most practical answer. Not everyone wants to use a cloud-based reporting solution, and not all aspects of SSRS have been rebuilt into Power BI paginated reports. It's only in the last few months that it got a partial option to replace data-driven subscriptions and that's still not feature complete. And there really is no good option for replacing SSRS in Standard or Express editions.

    Also, with Power BI, unless every user has a Power BI Pro or Power BI Premium Per User license, you need to have a Power BI Premium license to be able to use paginated reports. And with PBI premium licenses going away, that's going to mean that you need an equivalent Fabric license, which is even more expensive. With SSRS, you only needed the server license, and for Express, it was entirely free.

    What did change from 2016 onwards, is that it became a separate install, and you could only have a single instance of it installed on a server. (Previously it was a multi-instance app)

    2 people found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. ZoeHui-MSFT 41,446 Reputation points
    2024-04-22T01:49:29.6733333+00:00

    Hi @Colin Sachs,

    This article describes changes in SQL Server Reporting Services (SSRS), for versions 2017 and later.

    The newest update release is 16.0.8784.14010 published on 2024/01/23.

    I have not found any official documentation said that SSRS would no longer be available.

    Release notes for SQL Server Reporting Services (SSRS) 2017 and later

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  2. Colin Sachs 40 Reputation points
    2024-04-22T15:44:23.57+00:00

    Thanks all, just kind of confirmed what I already knew from my research.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.