OData Query, Azure Devops

Anonymous — Mon, 14 Feb 2022 01:37:56 GMT

Hi there, I am trying to display a pipeline test results summary page in Power Bi. This sample query works for pulling in a particular piplines at a time. But I am looking to get a summary for all pipelines, grouped by pipeline name.

If someone could help with the code for this it would be greatly appreciated.

Re: OData Query, Azure Devops

Anonymous — Thu, 17 Feb 2022 06:32:01 GMT

Hi @Anonymous ,

Please review the following documentation, hope it can help you get it.

Pipeline outcome summary for all pipelines sample report

let Source = OData.Feed ("https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/PipelineRuns?" &"$apply=filter( " &"CompletedDate ge {startdate} " &")" &"/groupby( " &"(Pipeline/PipelineName), " &"aggregate( " &"$count as TotalCount, " &"SucceededCount with sum as SucceededCount, " &"FailedCount with sum as FailedCount, " &"PartiallySucceededCount with sum as PartiallySucceededCount, " &"CanceledCount with sum as CanceledCount " &")) " ,null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4]) in Source

Best Regards

topic OData Query, Azure Devops in Developer

OData Query, Azure Devops

Re: OData Query, Azure Devops