question

AshleyDhevalall-8739 avatar image
0 Votes"
AshleyDhevalall-8739 asked AshleyDhevalall-8739 commented

OData services. Read cloud agents for Power BI reporting

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.

not-supported
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

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.





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.