VSTS.Feed returns incorrect columns

[Anonymous]

I am using VSTS.Feed so that I can query both the Azure DevOps OData and Rest services while only having to configure authorization once.

I have defined the folowing query in Power BI using VSTS.Feed:

let
    Source = VSTS.Feed("https://analytics.dev.azure.com/(organization)/(project)/_odata/WorkItems?$apply=aggregate(CompletedWork with sum as SumOfCompletedWork, RemainingWork with sum as SumOfRemainingWork)", [])
in
    Source

When I retrieve the data I expect two columns: SumOfCompletedWork and SumOfRemainingWork. However, Power BI shows all columns as defined in the metadata of the WorkItems entity:

I have debugged the HTTP calls that Power BI does using Fiddler and see that PowerBI retrieves the full endpoint metadata at url: https://analytics.dev.azure.com/(organization)/(project)/_odata/$metadata

While the OData result specifies the metadata as following: 

https://analytics.dev.azure.com/(organization)/(project)/_odata/$metadata#WorkItems(SumOfCompletedWo...)

So to me this seems like a bug in the VSTS.Feed function. Has anyone seen similiar behaviour or know how to fix this (using the VSTS data connector)?

[v-juanli-msft]

Hi @Anonymous 

Firstly please test your code in Visual Studio.

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect?view=azure-devops

It is said there are some updates for Azure DevOps Analytics.

https://stackoverflow.com/questions/60206820/power-bi-report-using-azure-devops-as-data-source-stopped-functioning

Alternatively, you could use odata or Azure DevOps connector to connect to Azure DevOps data,

then use other connectors to connect to "Rest Services",

It is support to combine or append data from different data sources in Power BI.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.