Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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)?
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |