SQL Server Reporting Services is done-zo:
Starting with SQL Server 2025, Microsoft is consolidating all on-premises reporting services under Power BI Report Server (PBIRS). No new versions of SQL Server Reporting Services (SSRS) will be released. PBIRS becomes the default on-premises reporting solution for SQL Server.
You can expect more information about specific editions when SQL Server 2025 is in General Availability (GA).
This article outlines the implications of these changes for you as a customer, and addresses any questions you might have.
The article claims that Power BI Report Server is a superset of SSRS. That might actually be so, but there’s a nagging part in the back of my brain saying that there are things we can do in SSRS that we can’t in PBIRS and that this won’t be the smooth transition that the article claims. But it’s been long enough since I’ve worked on SSRS in earnest to be able to say with certainty whether it’s the case.
H/T Blake McNeill.
TONS of SSRS Powerbi cant touch
Email delivery on-site and the ability to call Stored Procedures, Start SQL backups, call agent jobs, comes to mind
PBIRS is actually enterprise version , so you get Data-Driven Subs
No Subs in PBI
the cloud has its niche purposes