Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2016 (13.x) Reporting Services and later versions 
Power BI Report Server
Learn about what's new in the different versions of SQL Server Reporting Services. This article covers the major feature areas and is updated as new items are released.
For more information about SSRS, see What is SQL Server Reporting Services (SSRS)?
For information about Power BI Report Server, see What's new in Power BI Report Server.
SQL Server 2025 Reporting Services changes
Starting in SQL Server 2025 (17.x), on-premises reporting services is consolidated under Power BI Report Server. For more information, see Reporting Services consolidation FAQ.
SQL Server 2022 Reporting Services
Download SQL Server 2022 Reporting Services from the Microsoft Download Center.
This release introduces the new SQL Server 2022 (16.x) Reporting Services (SSRS). Innovation, creation, and design efforts focus on giving everyone the ability to achieve more. Designing for inclusivity reflects how people adapt to the world around them. In this new release of SSRS, significant accessibility improvements ensure broader empowerment and usability for users. The release includes:
- Windows Narrator support enhancements for the new Windows OS (Operating Systems) and Windows Server
- Security enhancements
- Browser performance improvements with Angular
- Accessibility bug fixes
- Support for SQL Server 2022 (16.x) instances report server catalog
- Reliability updates
Updated web portal
The web portal was updated with a contemporary look.
] Reporting Services web portal.](media/report-server-2022-web-portal.png?view=sql-server-2016)
Deprecated features
In 2020, deprecation of Report Server features Pin to Power BI, Mobile Reports, and Mobile Report Publisher was announced. These features were removed from versions of SQL Server starting with SQL Server 2022 (16.x) and are no longer supported. SQL Server 2016, SQL Server 2017, and SQL Server 2019 are supported in maintenance mode until End of Service (EOS) for existing customers.
When a feature is deprecated, it's in maintenance mode only. There's no new feature development, including changes related to interoperability with new features. Deprecated features usually remain in future releases to make upgrades easier. However, in rare situations, the feature might be permanently removed from Reporting Services if it limits future innovations.
Note
For new development work, don't use deprecated features.
SQL Server 2019 Reporting Services
Download SQL Server 2019 Reporting Services from the Microsoft Download Center.
Azure SQL Managed Instance support
You can now host a database catalog used for SSRS in an Azure SQL Managed Instance (MI) either on a virtual machine (VM) or in your data center. Support is limited to database credentials for the connection to SQL MI.
Power BI Premium dataset support
You can connect to Power BI datasets by using either Microsoft Report Builder or SQL Server Data Tools (SSDT). Then you can publish those reports to SSRS 2019 by using SQL Server Analysis Services (SSAS) connectivity and use a stored Windows username and password to enable the scenario. For more information about SSAS, see - What's new in SQL Server Analysis Services
AltText (alternative text) support for report elements
When you author reports, use tooltips to specify text for each element on the report. Screen reader technology identifies these tooltips properly.
Microsoft Entra application proxy support
Note
Microsoft Entra ID was previously known as Azure Active Directory (Azure AD).
With Microsoft Entra application proxy, you no longer need to manage your own web application proxy to allow secure access through the web or mobile apps.
Custom headers
Sets header values for all URLs matching the specified regex pattern. You can update the custom header value with valid XML to set header values for selected request URLs. Administrators can add any number of headers in the XML. For more information, see Custom headers.
Transparent data encryption
SQL Server 2019 (15.x) supports transparent data encryption (TDE) for the SSRS catalog database in the Enterprise and Standard editions.
Microsoft Report Builder update
The newly released version of Report Builder is fully compatible with the 2016, 2017, and 2019 versions of Reporting Services. It's also compatible with all released and supported versions of Power BI Report Server.
SQL Server 2017 Reporting Services
Download SQL Server 2017 Reporting Services from the Microsoft Download Center.
Comments on reports
Comments are available for reports. Comments can add perspective and help you collaborate with others. You can also include attachments with comments.
For more information, see Add comments to a report in a report server - Power BI Report Server.
REST API support
To enable development of modern applications and customization, SSRS supports a fully OpenAPI-compliant RESTful API. For information about the full API specification, see SwaggerHub.
Query designer support for data analysis expressions (DAX)
In Report Builder and SSDT, you can create native DAX queries against supported SSAS tabular data models. Use the query designer in both tools to drag and drop the fields you want. The DAX query is then generated for you.
For more information, see Reporting Services blog.
- Download SQL Server Report Builder.
- Download SQL Server Data Tools.
Note
You can only use the query designer for DAX with SSAS tabular data sources built in SQL Server 2016+.
SharePoint integrated mode is deprecated
SharePoint integrated mode is deprecated after SQL Server 2016. To add Reporting Services reports to SharePoint, use the Report Viewer web part on a SharePoint site - Reporting Services.