SQL Server 2025 – Retirement of SQL Server Reporting Services (SSRS)

Microsoft has announced the end of the SQL Server Reporting Services (SSRS) service. In other words, Microsoft will no longer provide new versions of SSRS. Currently, the latest available version is the 2022 version (https://www.microsoft.com/fr-FR/download/details.aspx?id=104502).

However, it is important to note that this service will be supported until January 11, 2033. Moreover, it will still be possible to use SSRS and host databases from this service on a recent version of SQL Server.

The replacement for SQL Server Reporting Services (SSRS) is Power BI Report Server (PBIRS). This is the service to adopt for future installations. In fact, we have observed that many clients have been using Power BI Report Server for several years.

Reference: https://www.microsoft.com/en-us/sql-server/blog/2025/06/19/enhancing-reporting-and-analytics-with-sql-server-2025-tools-and-services/

I use SQL Server Reporting Services and would like to migrate to Power BI Report Server. What are my options?

Several solutions are possible (the following list is neither exhaustive nor in any particular order):

• Migrate the databases that support the SSRS service to PBIRS
  • Current environment:
    • Server 1 (S1):
      • Hosted services: SSRS and SQL Server Database Engine. The SSRS service and my databases are hosted on my S1 server.
  • New environment:
    • Server 2 (S2):
      • Hosted services: PBIRS and SQL Server Database Engine. The PBIRS service and the database engine are hosted on my S2 server.
      • We will migrate the databases from S1 to S2.
      • The PBIRS service will connect to the migrated databases.

Reference: https://learn.microsoft.com/en-us/power-bi/report-server/migrate-report-server

• Use the RDL Migration Tool (RdlMigration) to migrate reports from SSRS to PBIRS

Reference: https://github.com/microsoft/RdlMigration

• Use the Reporting Services PowerShell API, which allows for fine-grained control over the migration of reports

Reference: https://github.com/microsoft/ReportingServicesTools

I am currently using SSRS 2022 and would like to migrate to Power BI Report Server. What are my options?

According to the documentation (as of now), it is currently not possible to migrate from SSRS 2022 to Power BI Report Server.

Reference: https://learn.microsoft.com/en-us/power-bi/report-server/migrate-report-server

Thank you, Amine Haloui.