Example reports for Power BI Data Connector

Last Update: 1/21/2017

Team Services

NOTE

Feature availability: The Analytics Service is in private preview and only available to select customers of Visual Studio Team Services at this time.

Steps are provided to support generating the following example reports:

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