data-connector-examples.md

title	titleSuffix	description	ms.assetid	ms.technology	ms.topic	ms.author	author	monikerRange	ms date
Example reports for Power BI Data Connector	Azure DevOps	Learn how to develop reports based on examples when using the Power BI Data Connector and Analytics for Azure DevOps.	3356B3EF-E9AB-4B42-8738-E58AA34A4B4F	devops-analytics	sample	kaelli	KathrynEE	>= azure-devops-2019	10/04/2021

Example reports for Power BI data connector

[!INCLUDE version-gt-eq-2019]

Learn how to generate the following example reports in Power BI:

• Number of Work Items
• Number of Bugs by Area Path and Priority

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.

[!INCLUDE temp]

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.

   

Related articles

• Power BI integration overview
• Connect with Power BI Data Connector
• Dataset design for the Power BI Data Connector
• Functions available in Power BI Data Connector