Azure DevOps Server 2022 Deprecation of Reporting Services

Dan Hellem

As part of the Azure DevOps Server 2022 release, we wanted to reiterate the deprecation of the existing data warehouse reporting services. We previously announced this in the Azure DevOps Server 2020 release notes. The warehouse reporting service has been part of TFS and Azure DevOps for over a decade. We felt this release was the right time to deprecate the old technology and debt while we continue our commitment with the new Analytics Service.

Hello Analytics Service 👋

In Azure DevOps Server 2019.1, we released the Analytics Service as part of the core product. This service opened up a variety of new reporting scenarios:

  • Enabled several new dashboard widgets
  • In-context reports such as team velocity, sprint burndown, etc.
  • Roll-up columns
  • Integration with Power BI reports
  • Analytics data that is fully accessible via OData

We continued to add features and improve on the Analytics Services in Server 2020.

If you are not familiar with the Analytics Service, please see this documentation to get started.

What happens when I upgrade?

When upgrading to Azure DevOps Server 2022, you will be required to disable the existing warehouse reporting services. The update wizard will automatically disable it for you. Disabling of the reporting services is required to complete the Server 2022 upgrade.

Image of Azure DevOps Server 2022 wizard

What about existing reports?

Many of your existing reports will be accessible by a combination of the Analytics Service features as described above. Some of them will be solved using Dashboard Widgets and others will be solved with Analytics views or custom OData queries.

screen shot of dashboard widget

For customized reports, you can use Analytic Views to generate a view of data you need and export that into Power BI. To get you started, a set of default Analytics views are defined for each project. You can then view, modify, and create your own views to fit your needs.

screen shot default analytics views

Existing reports are not migrated into the Analytics Service. You will need to re-create the reports and charts manually. Please review the below documentation and create your new reports before starting your Azure DevOps 2022 upgrade.

Learn more

The Analytics Service has been available since Azure DevOps Server 2019.1 and is ready to be the sole reporting solution for both the service and on-prem products. We hope you find this article as a useful guide to prepare yourself for Azure DevOps Server 2022 and the changes to the Reporting Services.

Here are some helpful resources on getting started and building reports with the Analytics Service.