Cross Organization query in Azure DevOps
There might be different Azure DevOps Organizations within a company. Sometimes there might be a need to query the data across multiple orgs. Though Azure DevOps doesn’t provide an UI interface through which you can get the data from multiple organizations, there are still couple of ways using which you can get the data across organizations
Custom Scripts: If it’s a one time activity or a repetitive activity, you can write some custom scripts using Azure DevOps API call using which you get the data across different Azure DevOps organizations
Using PowerBI: This is one of the best methods to get data from different Azure DevOps organizations and collate it in a single table. But the problem with PowerBI, to access the data PowerBI prolicense is needed which is very costly as each and every user needs to have a PowerBI pro license to have access to those Dashboards in PowerBI workspace.