OData services. Read cloud agents for Power BI reporting

Question

Good day all

I have been using the following endpoints to retrieve data from Azure Devops

https://analytics.dev.azure.com/{org}/_odata/v3.0-preview/Pipelines

{
    ProjectSK: "5f03fcfd-0000-0000-000-c45092c395dc",
    PipelineSK: 1277,
    PipelineId: 4,
    PipelineName: "BackOffice",
    PipelineVersion: 2,
    PipelineProcessType: "Yaml"
}

https://analytics.dev.azure.com/{org}/_odata/v3.0-preview/PipelineRuns

{
  ProjectSK: "5f03fcfd-0000-0000-0000-c45092c395dc",
  PipelineRunSK: 877,
  PipelineRunId: 94,
  PipelineId: 19,
  PipelineSK: 50,
  BranchSK: 503224,
  RunNumber: "5.23.6.13094-AzurePipelines",
  RunNumberRevision: 1,
  RunReason: "Schedule",
  RunOutcome: "Succeed",
  QueuedDate: "2019-12-14T00:00:00+02:00",
  QueuedDateSK: 20191214,
  StartedDate: "2019-12-14T00:00:15+02:00",
  StartedDateSK: 20191214,
  CompletedDate: "2019-12-14T00:09:01+02:00",
  CompletedDateSK: 20191214,
  RunDurationSeconds: 526.326,
  QueueDurationSeconds: 14.651,
  TotalDurationSeconds: 540.977,
  SucceededCount: 1,
  PartiallySucceededCount: 0,
  FailedCount: 0,
  CanceledCount: 0
}  

Can we retrieve the associated agent pool that executed the pipeline run using the existing odata feeds?

We have a requirement to display the capacity of the Cloud agents on a Power BI dashboard.

I am able to retrieve this information using

https://dev.azure.com/{org}/_apis/distributedtask/pools/9/jobrequests.

However this end point only returns 500 entries on each request and requires me to persist the information in a database to maintain history :(

Any assistance would be highly appreciated.

Answer 1

Power Bi is not currently supported here on QnA. They're actively answering question in dedicated forums here.

https://community.powerbi.com/

--please don't forget to Accept as answer if the reply is helpful--

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.