Microsoft has confirmed that SQL Server Reporting Services 2022 is the last version of SSRS. From SQL Server 2025, on-premises reporting moves to Power BI Report Server. Nothing switches off tomorrow, but every SSRS server now has a horizon, and the reports on it need a plan.

The dates that matter

  • SQL Server 2016, including its SSRS: extended support ended on 14 July 2026. Security fixes now need paid extended security updates.
  • SQL Server 2017: extended support ends on 12 October 2027.
  • SQL Server 2019: extended support ends on 8 January 2030.
  • SSRS 2022: supported until 11 January 2033, and there will be no newer version.

Your options

  • Stay on SSRS for now. Supported versions keep receiving fixes until their end dates. That buys time, but not a destination.
  • Move to Power BI Report Server. It runs SSRS paginated reports alongside Power BI reports on your own servers, and Microsoft says most SSRS reports are compatible.
  • Move to the Power BI service. Paginated reports run in the cloud, which suits organisations already standardising on Power BI and Microsoft Fabric.
  • Retire what nobody uses. Often the biggest saving: every report you switch off is one you never have to migrate or test.

Why SSRS moves go wrong

The technical move is rarely the hard part. The trouble is what the report server has quietly become after years of use.

  • Nobody knows which reports are still used, so everything goes on the migration list.
  • Reports feed workbooks, scheduled emails and other systems that nobody documented.
  • The same KPI is calculated differently in different reports, and the differences move with you.
  • The people who built the reports have left, so nobody can sign off what a report should do.

A practical plan

  • Build a complete inventory: every report, data source and subscription, plus the workbooks that depend on them.
  • Find the copies and the unused reports, and agree with owners which ones to retire.
  • Map dependencies, so you know what breaks if a report moves or disappears.
  • Agree one definition for each KPI before rebuilding, so the new platform starts clean.
  • Move in waves, starting with what everything else depends on, and check results against the old reports before switch-off.

A switch-off date is a business decision. The sooner the evidence is in front of the people who own the reports, the less of that decision is a guess.