Forum Discussion
Legacy SSRS reports after upgrading Azure DevOps Server 2020 to 2022 or 25H2
We are currently planning an upgrade from Azure DevOps Server 2020 to Azure DevOps Server 2022 or 25H2, and one of our biggest concerns is reporting.
We understand that Microsoft’s recommended direction is to move to Power BI based on Analytics / OData. However, for on-prem environments with a large number of existing SSRS reports, rebuilding everything from scratch would require significant time and effort.
Since Warehouse and Analysis Services are no longer available in newer versions, we would like to understand how other on-prem teams are handling legacy SSRS reporting during and after the upgrade.
Have you rebuilt your reports in Power BI, moved to another reporting approach, or found a practical way to keep existing SSRS reports available during the transition?
Any real-world experience, lessons learned, or recommended approaches would be greatly appreciated.
1 Reply
Azure DevOps Server 2022 and 25H2 no longer support the legacy Reporting Warehouse or Analysis Services, meaning SSRS reports tied to those data sources will break after upgrade. The only supported path forward is migrating reporting to Power BI using the Analytics Service/OData feed. There is no official method to keep SSRS reports functional post-upgrade.
https://devblogs.microsoft.com/devops/azure-devops-server-2022-deprecation-of-reporting-services/
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data
