Example reports for Power BI Data Connector

VSTS

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

Prior to generating these reports, you must first connect to the Analytics Services for VSTS 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.

  3. Search for Work Item Count and drag it to the 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.

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

  4. Search for Priority and drag it to Columns.

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

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