Forum Discussion
OData Query to fetch multiple Devops project in the same Org using PowerBI
Hi Team, I am trying to fetch the data for more than one DevOps project in the same Organization using Power BI. Could you please help . Thank you, Jeet
Hello amitchandak
This is the sample of query that is working. But i am not sure how it can be executed to get the data for multiple projects.
let
Source = OData.Feed ("https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/WorkItemSnapshot? "
&"$apply=filter( "
&"WorkItemType eq 'Bug' "
&"and StateCategory ne 'Completed' "
&"and startswith(Area/AreaPath,'{areapath}') "
&"and DateValue ge {startdate} "
&") "
&"/groupby( "
&"(DateValue,State,WorkItemType,Priority,Severity,Area/AreaPath,Iteration/IterationPath,AreaSK), "
&"aggregate($count as Count) "
&") "
,null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4])
in
Source