Changes / Databases & SQL tools / Microsoft SQL Server
End of supportmedium impact
No new SSRS versions: Power BI Report Server replaces SSRS from SQL Server 2025
Microsoft will release no new SSRS versions from SQL Server 2025 on and consolidates on-premises reporting under Power BI Report Server.
Who’s affected
Teams running on-premises SSRS (native or SharePoint-integrated paginated reports) that plan to move to SQL Server 2025 or later and expected a new SSRS release to come with it.
Not affected: Teams on existing SSRS versions that stay on them: those versions remain supported per their lifecycle. Teams that already use Power BI Report Server or the Power BI service for paginated reports.
What it costs
The record gives no prices, so there is no direct bill change. The real cost is migration effort: moving SSRS content to Power BI Report Server, re-testing reports and subscriptions, and checking licensing for PBIRS against what you already own.
When to act
No single effective date exists, so plan against your current SSRS version's support end and allow roughly 4-6 months to inventory, test and migrate reports before that date.
Blast radius: SSRS-hosted RDL reports, scheduled subscriptions, shared data sources, SharePoint-integrated deployments, custom extensions and any URL or API integrations pointing at the report server.
What should you do? decision tree
- you run SSRS on a version that is still in support and have no SQL Server 2025 upgrade plannedStay put, note your version's support end date from the lifecycle page, and schedule the PBIRS move before that date.
- you are planning a SQL Server 2025 upgrade and use SSRSAdd Power BI Report Server to the project scope, because there will be no new SSRS version to install.
- you already license Power BI Premium or SQL Server with Software AssuranceConfirm with your Microsoft rep that this entitles you to Power BI Report Server, and get it in writing before budgeting new spend.
- your reports are mostly paginated (RDL) and you want to leave on-premisesEvaluate moving them to the Power BI service or Fabric paginated reports instead of PBIRS.
- none of the above fitsInventory your SSRS reports, subscriptions and data sources now and run a pilot PBIRS migration on a copy of a few reports.
Options
- WaitStay on the current SSRS version while it is supported; no action needed until its support end date approaches.
- OptimizeRetire unused reports and consolidate duplicates now so the eventual migration covers fewer items.
- MigrateMove SSRS content (RDL, shared datasets, subscriptions) to Power BI Report Server and test rendering, security and schedules.
- Re-architectShift paginated reports to the Power BI service or Fabric if you want to drop the on-premises report server entirely.
Alternatives editorial picks, not sponsored
The facts straight from the source
Facts above are extracted from the source and checked word-for-word before publishing. The guidance sections are AI-assisted analysis based only on those facts: a starting point, not legal or procurement advice. Spotted an error? Tell us.
Related changes
- Microsoft SQL ServerAzure Data Studio retired
Azure Data Studio was retired on February 28, 2026 and no longer receives updates or security fixes; Microsoft directs users to Visual Studio Code with the MSSQL extension.
End of support - Microsoft SQL ServerSQL Server 2016 (incl. SSIS/SSAS/SSRS 2016) reaches end of support
SQL Server 2016 reached end of support on July 14, 2026, so Microsoft no longer provides regular security updates or technical support; paid ESU is offered as a bridge.
End of support - Microsoft SQL ServerPower BI Report Server rights on SQL Server 2022 Enterprise now tied to active SA
For SQL Server 2022 and earlier, PBIRS usage rights apply only to Enterprise core licenses with active Software Assurance and end when SA expires.
License