Example reports for Power BI data connector

Azure DevOps Services | Azure DevOps Server 2020 | Azure DevOps Server 2019

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

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

  • You must be a member of a project with Basic access or higher. If you haven't been added as a project member, get added now. Anyone with access to the project, except stakeholders, can view Analytics views.
  • For Analytics data to be available, the corresponding service must be enabled. For example, to query work tracking data, Boards must be enabled. If it is disabled, Analytics views won't be displayed. To re-enable a service, see Turn an Azure DevOps service on or off
  • To use Analytics views, enable the Analytics Views preview feature either for individual users or for the organization.
  • Also, you must have your *View Analytics permission set to Allow. For more information, see Grant permissions to access the Analytics service.
  • To use Power BI for Azure DevOps or to exercise an OData query for Analytics, you must must have your View Analytics permission set to Allow. By default, all Contributors with Basic access are granted access. To edit shared Analytics views, you must have your *Edit shared Analytics views permission set to Allow. For more information, see Grant permissions to access the Analytics service.
  • You must be a member of a project with Basic access or higher. If you haven't been added as a project member, get added now. Anyone with access to the project, except stakeholders, can view Analytics views.
  • Verify that Analytics is installed, and if not, then enable it. You must be an account owner or a member of the Project Collection Administrator group to add extensions or enable the service.
  • For Analytics data to be available, the corresponding service must be enabled. For example, to query work tracking data, Boards must be enabled. If it is disabled, Analytics views won't be displayed. To re-enable a service, see Turn an Azure DevOps service on or off
  • To use Analytics views, enable the Analytics Views preview feature either for individual users or for the organization.
  • Also, you must have your *View Analytics permission set to Allow. For more information, see Grant permissions to access the Analytics service.
  • To use Power BI for Azure DevOps or to exercise an OData query for Analytics, you must must have your View Analytics permission set to Allow. By default, all Contributors with Basic access are granted access. To edit shared Analytics views, you must have your Edit shared Analytics views permission set to Allow. For more information, see Grant permissions to access the Analytics service.

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