Jaa


Reporting roadmap for Azure DevOps

TFS 2018

The Analytics service provides support for Azure DevOps reporting. It is available for Azure DevOps Server 2019 and later versions. It replaces the previous platform based on SQL Server Reporting Services.

With the release of Azure DevOps Server 2022, the only option for gaining Azure DevOps data insights is the Analytics service. Integration with SQL Server Reporting Services is no longer supported. For guidance on migrating from using SQL Reporting Services to Analytics, see Migrate to Analytics from SQL Reporting Services for Azure DevOps.

For additional information, see the following articles:

Note

If you are looking for information about the Azure Analysis Services, see Azure Analysis Services.

The Analytics service

Analytics is in Public Preview for Azure DevOps Server 2019 and later versions. You gain access to it by enabling or installing Analytics. Analytics provides several advanced widgets, Power BI integration, and access to the OData feed.

Team Foundation Server (TFS) 2018 and earlier versions don't support Analytics.

To learn more, see What is Analytics. It currently contains partial data. We're working to add all reportable data to Analytics. For more information, see Data Available in Analytics.

Azure DevOps Server, TFS, and SQL Server Reporting

Since Team Foundation Server (TFS) was released in 2005, we've offered a reporting solution based on a data warehouse and OLAP cube, coupled with a SQL Server Reposrting Services server to host reports.

TFS Data warehouse architecture conceptual diagram

While the configuration is complex, it provides a powerful solution. You can create custom reports by writing customized SSRS reports. You can also create reports using Excel, and share them on SharePoint once you've configured SharePoint to host Excel Charts.

We have no plans to bring a cloud version of our SQL Server Reporting story to Azure DevOps Services.

Future of SQL Server Reporting

The SQL Server Reporting Services platform is supported on all on-premises deployments from Azure DevOps Server 2020 and earlier versions. Azure DevOps Server 2020 is the last version to support SQL Server Reporting. Future versions will support only Analytics. This plan allows customers time to convert their reports to Analytics.

Roadmap timeline

Check out the Features Timeline for the roadmap of reporting features.