I want to retrieve the backend data that's used to specifically drive the Azure DevOps Analytics Velocity Dashboard Report [Committed and Completed Points for each interaction]. I would like to pull this data either using OData feed or the Visual Studio Team Services (Beta) in order to create custom PowerBI reports
[1] Example of the report I'm trying to pull the data from can be found here:https://docs.microsoft.com/en-us/azure/devops/report/analytics/_img/velocity-ax-catalog.png?view=vsts
Why you have to retrieve the data? You can directly create Power BI reports using Analytics views.
Please see What are Analytics views for details.
When using the Power BI Data Connector, these same default views appear in the Navigator dialog. The view you select determines the set of records, fields, and history which are loaded into Power BI.
Default Analytics views work well for customers with small datasets. To learn more, see Default Analytics views.
If the default Analytics views do not meet your needs, you can create custom views to fine-tune the records, fields, and history returned to Power BI.
Please see below links for more information:
I was able to replicate the Velocity report by using the "Stories - All history" view. You would need to modify the view to track daily history and then use the Iteration start date/Iteration end date along with the "date" column to filter out the Committed and Completed data.
