Edit

Analytics query tools in Azure DevOps

  • Article

Azure DevOps Services | Azure DevOps Server 2022 - Azure DevOps Server 2019

You can query Analytics from a web browser or other supported tools. To create reports, we recommend you use Power BI. Power BI is free and provides a suite of business analytics tools that you can use to perform impromptu analysis, produce reports, and publish reports for enterprise consumption.

To help you get started, use the guidance provided in the following table to determine which tool you should use based on the task you want to accomplish.

Task Tool Notes
Query the metadata Any supported web browser Review the Analytics data model consisting of EntityTypes, properties, enumerated member names, supported functions, and more. To get started, see Query the Analytics service.
Create a status or trend report for work tracking data Analytics views
Power BI		 Use a default view or create a custom view to filter work tracking data. To learn more, see Create a Power BI report with a default Analytics view.
Create a report from a work item query WIQL to OData extension
Power BI		 Install the extension to get an OData query based on the filtered set of work items. Then use Create a Power BI report with an OData Query.
Create reports or dashboards based on Analytics data Power BI You can specify a Power BI query or OData query within Power BI to filter the data. To learn more, see Overview of sample reports using OData queries.
Write and test OData Visual Studio Code
OData for Visual Studio Code		 Visual Studio Code is a free code editor available on Windows, Mac, and Linux. The OData extension provides syntax highlighting and other functions that are useful for writing and testing queries.