Forum Discussion
Legacy SSRS reports after upgrading Azure DevOps Server 2020 to 2022 or 25H2
Thanks for the reply.
We may have found a workable approach for this and are currently validating it internally.
If helpful, I can also share the solution we are testing:
https://www.warehousesync.net/
If the test results continue to look good, I’ll come back and share an update.
Following up on my earlier post, I’d like to share the results of our internal testing.
We have confirmed that the existing SSRS reports in RDL format that query the Warehouse database can run on Power BI Report Server (PBIRS) in our test environment. With WarehouseSync keeping the required Warehouse data updated, we were able to continue serving these reports through PBIRS.
This provides a workable reporting continuity option for the reports we tested: using PBIRS to host and execute the RDL reports, and WarehouseSync to maintain the underlying Warehouse data.
These results apply to our tested Warehouse-based reports. Other reports would need to be checked against their specific data sources and dependencies.