What are Analytics views?
Azure DevOps Services | Azure DevOps Server 2020 | 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 and tests. Each view corresponds to a flat-list of work items. Work item hierarchies aren't supported.
You can use a default Analytics view or create a custom view. You create custom views in the web portal for Azure DevOps. Once you've defined a view that supports the data of interest, you can then open the view using Power BI Data Connector to create a report.
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
A 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 is pulled into Power BI.
To access Analytics views, you must enable the feature as described in Manage or enable 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 is 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 don't meet your needs, you can create custom views to fine-tune the records, fields, and history returned to Power BI. With a custom view, you can define 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 Analytics views dataset design.
- Create a Power BI report with a default Analytics view
- Connect to Analytics with Power BI Data Connector
- What is Power BI Desktop?
- Data available from Analytics
- Query work tracking data using Analytics
- Analytics work item fields reference
Submit and view feedback for