OData Query, Azure Devops

[liamcol1]

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. 

[v-yiruan-msft]

Hi @liamcol1 ,

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