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 Analytics data.
Analytics views only support Azure Boards data (work items). Analytics views don't support other data types, such as Pipelines. Views provide a flat-list of work items, and don't support work item hierarchies. At this point, we have no plans to update the connector to support other types of data. For information on other approaches, read Power BI Integration Overview.
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.
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.
To access Analytics views, you must enable the feature as described in Enable preview features.
Here we show the default views created for a project based on the Agile process. To learn how to open this view in your web portal, see Manage Analytics views.
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—Basic, Agile, Scrum, or CMMI. However, the basic functionality available to you remains the same unless explicitly mentioned.
When you use 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 that are loaded into Power BI.
Default Analytics views work well for customers with small datasets. To learn more, see Default Analytics views.
Custom 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.
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
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