Example reports for Power BI Data Connector

Azure DevOps Services | Azure DevOps Server 2019

This document provides guidance on how to generate the following example reports in Power BI:

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

Tip

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

Number of work items

  1. Load Work Items - Today table with columns: Work Item Count.

  2. Select Card visual.

    Power BI Visualizations, choose Card visual

  3. Search for Work Item Count and drag it to the Fields.

    Power BI, Filter for Work Item Count, add to fields

Number of bugs by area path and priority

  1. Load Work Items - Today table with columns: Area Path, Priority, Work Item Count, Work Item Type.

  2. Select Matrix visual.

    Power BI Visualizations, choose Matrix visual

  3. Search for Area Path and drag it to Rows.

    Power BI, Add Area Path to Rows

  4. Search for Priority and drag it to Columns.

    Power BI, add Priority to Columns

  5. Search for Work Item Count and drag it to Values.

    Power BI, add Work Item Count to Values

  6. Search for Work Item Type, drag it to Visual level filters and select Bugs.

    Power BI, Add Work Item Type to Visual Level Filters, Filter on Bug