What are Analytics views?

Azure DevOps Services | Azure DevOps Server 2019

An Analytics view provides a simplified way to specify the filter criteria for a Power BI report based on the Analytics Service data store. The Analytics Service provides the reporting platform for Azure DevOps.

Each view defines a dataset designed to support viewing, sharing, and publishing work tracking data for Azure DevOps through Power BI. You can use default Analytics views or create custom views and open the view using the Power BI Data Connector. You create custom views in the web portal for Azure DevOps.

You can use the default Analytics views we provide or create your own custom views.

Note

If Boards is disabled, then Analytics views will also be disabled and all widgets associated with work item tracking won't appear in the widget catalog and will become disabled. To re-enable a service, see Turn an Azure DevOps service on or off.

Default Analytics views

As set of default Analytics views are provided. The default views and are immediately accessible from Power BI. The view you select determines the set of records, fields, and history that are pulled into Power BI.

Here we show the default views created for a project based on the Agile process.

Default Analytics views

Note

The labels you see for the list of default Analytics views will differ depending on the process that was chosen when creating your team project—Agile, Scrum, or CMMI. However, the basic functionality available to you remains the same unless explicitly mentioned.

When using the Power BI Data Connector, these same default views appear in the Navigator dialog. The view you select determines the set of records, fields, and history which are loaded into Power BI.

Power BI Azure DevOps Connector (Beta)

Power BI Azure DevOps Server Connector (Beta)

Default Analytics views work well for customers with small datasets. To learn more, see Default Analytics views.

If the default Analytics views do not meet your needs, you can create custom views to fine-tune the records, fields, and history returned to Power BI.

Custom Analytics views

Customers that need to fine-tune the records, fields, and history of data they view in Power BI can create custom Analytics views. A custom view supports defining the following options:

  • Sharing options
  • Work item filters
  • Team and area path filters
  • Backlog and work item type filters
  • Field specific filters
  • Fields to display
  • View history and trend options

To learn more, see Create an Analytics view.

How the data is modeled in Power BI

The dataset built for Analytics views in Power BI is modeled to make it easy to get started with Power BI reports.

For more information on how the dataset is modeled when using the Power BI Data Connector, see dataset design for the Power BI Data Connector.

Try this next