Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

VSTS.Feed returns incorrect columns

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(SumOfCompletedWork,SumOfRemainingWork)

 

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)?

1 Reply