Edit

Example reports based on Analytics views

  • Article

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

Learn how to generate the following example reports in Power BI based on an Analytics view.

Before generating these reports, you must first connect to Analytics using the Power BI data connector.

Tip

Use the search box if you are working with tables that contain many columns.

Prerequisites

  • To view Analytics data and query the service, you need to be a member of a project with Basic access or greater. By default, all project members are granted permissions to query Analytics and define Analytics views.
  • To learn about other prerequisites regarding service and feature enablement and general data tracking activities, see Permissions and prerequisites to access Analytics.

Show card with total count of work items

  1. Load the Work Items - Today Analytics view into Power BI.

  2. From the Visualizations pane, choose Card, and drag the Work Item ID to Fields.

    Screenshot of Power BI Visualizations, choose Card and add Work Item ID to Fields.

Number of work items by area path and state

  1. Load Work Items - Today Analytics view into Power BI. The data table should include the following columns: Area Path, Assigned To, Iteration Path, State, Title, Work Item ID, and Work Item Type.

  2. From the Visualizations pane, choose Matrix, and add Area Path, State, and Work Item ID to Rows, Columns, and Values, respectively.

    Screenshot of Power BI Visualizations, choose Matrix and add Area Path, State, and Work Item ID fields to Rows, Columns, and Values.

  3. (Optional) Expand the Filters pane and choose one or more fields to filter the report. For example, the example report shown in the previous image only shows select Area Paths.

    Screenshot of Power BI Filters, select Area Paths.

    Note

    To simplify the report, select Area Paths were renamed to shorten their labels. To learn how to replace values in a column, see Transform Analytics data to generate Power BI reports, Replace values.

  4. To filter on other fields, such as Iteration Path or Work Item Type, drag the field to Columns in the Visualizations pane, and then filter the data from the Filters pane.