SQL Server Reporting Services. Used on premises to create, deploy and manage paginated reports, it has been consolidated, from SQL Server 2025 onwards, into Power BI Report Server for on-premises reporting.
Also called SQL Server Reporting Services.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains SSRS in context, with comparison tables and the common traps.
Terms in this definition
- CRUD
Shorthand for create, read, update and delete, the four basic things you do with data. Data-plane roles in Azure Cosmos DB, for instance, authorise those operations on items.
- MANAGE
A Unity Catalog privilege allowing a principal to grant and revoke access on an object, hand over its ownership and drop it, all without being the owner. It gives no data access by itself and is not part of
ALL PRIVILEGES. - SQL Server 2025
This SQL Server version brings AI into the engine itself: a vector type with vector indexes, external models, and AI_GENERATE_EMBEDDINGS. Native json and regular expression functions arrived with it too.
- Power BI Report Server
Lets organisations keep Power BI reports, Excel workbooks and paginated reports inside their own network, published through a web portal they host themselves. Content comes from a dedicated edition of Power BI Desktop, and licences come with P SKUs or with SQL Server Enterprise plus Software Assurance.
Related terms
- RDL
Paginated reports are saved as .rdl files, an XML format describing both layout and how data is retrieved. Power BI Report Builder creates them, and existing SSRS reports in this format can move to Power BI.