OData Query to fetch multiple Devops project in the same Org using PowerBI

Paramjit , Not very clear to me. But check if you can loop using this pagination approach

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78

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