All posts
Microsoft Data Platform

There Will Be No New SSRS: Power BI Report Server, Power BI, or Moving Reports Elsewhere

By

October 25, 2026

6 min read

Starting with SQL Server 2025, Microsoft consolidates on-premises reporting into Power BI Report Server and will release no new versions of SQL Server Reporting Services. What that means for estates full of RDL reports, the licensing, and when it makes sense to move reporting off SQL Server entirely.

SSRS
Power BI Report Server
SQL Server 2025
Reporting
Paginated Reports

SQL Server Reporting Services has run invoices, statements and operational reports for twenty years. Microsoft's Reporting Services consolidation FAQ is clear: starting with SQL Server 2025 there will be no new SSRS versions, and Power BI Report Server becomes the on-premises reporting product. Existing SSRS versions follow the lifecycle of the SQL Server release they shipped with; SSRS 2016 lost support with SQL Server 2016 in July 2026.

What Power BI Report Server is

  • A superset of SSRS: it runs the same paginated RDL reports, plus interactive Power BI (PBIX) reports.

  • Licensed with SQL Server 2025 Enterprise and Standard: the same product key installs it.

  • On the Modern Lifecycle Policy, so it updates regularly and you must stay current, unlike the fixed ten-year SSRS releases.

Want a second opinion on this for your system?

Book a free 30-minute call. You'll leave knowing what we'd do first and roughly what it costs, whether or not you hire us.

Three paths

Path

Fits when

Watch for

Power BI Report Server on-premises or on EC2

Reports must stay near on-premises data; RDL estate is large

Modern Lifecycle means regular upgrades; licensing tied to SQL Server 2025 or a Fabric reservation

Power BI service with paginated reports

You are on Microsoft 365 and Fabric; you want one reporting platform

Capacity sizing; gateway for on-premises data

Move reporting off Microsoft

Data is moving to AWS anyway; reports are mostly operational

RDL does not convert automatically; rebuild the reports that are used

The step most teams skip

SSRS keeps an execution log. Query it before migrating anything. In most estates a large share of reports have not been run in a year, and a small number account for most executions. Migrate the used ones, archive the definitions of the rest, and tell owners what was retired. A smaller estate makes every path cheaper.

hoolco Monthly Review

Once a month: what changed in tech that month and what it means for you, from cloud and AI to security and the tools you build with. Every item links to its source. No sales pitch, unsubscribe in one click.

As of October 25, 2026. Provided as is, for general information, and accurate to the best of our knowledge on the date shown. Not legal, compliance, tax, financial or other professional advice. Prices, limits and vendor services change; check current vendor documentation before relying on anything here. Terms of use.