Power BI integration overview

VSTS

Note

Feature availability: The Analytics Marketplace extension is available to all VSTS accounts and provides access to several useful
widgets, such as Cumulative Flow, Velocity, and Lead and Cycle Time. The Analytics OData endpoint, which provides a concise model over the VSTS suite for Work Item Tracking, Test, Version Control, and
Build, is in a closed preview and only available to select VSTS customers at this time.

If you are looking for information about the Azure Analysis Services, see Azure Analysis Services or What is Azure Analysis Services?.

Gain insight and analyze the progress and quality of your project by connecting Power BI to the data collected and stored in VSTS. Currently, you can choose between two different options depending on your reporting requirements.

The first option, the Content Pack, contains a complete analytic data model (tables, relationships and measures), a set of default reports and a default dashboard. Reports and dashboard are fully customizable but the data model is not. All VSTS customers can use the Content Pack to generate dashboards and reports.

This option is great for users who want to get quick insights without the need of building custom models. The data model is shared between all users and therefore does not support process customization, this is one of the primary reasons to consider the second option. To learn more, see Connect to VSTS with Power BI Content Pack.

The second option, Data Connector, has been released with the Power BI Desktop January 2017 Update. This option is available in the Power BI Desktop. It allows users to select the data they are interested in, which includes support for a fully customized data model by including project-specific fields, work item customizations, and adding tables from additional data sources.

Since you select which data to load, this approach works well for very large accounts, that could not use the Content Pack in the past. To learn more, see Connect to VSTS with Power BI Data Connector.

The following table contains a detailed comparison of both options.

Content Pack Data Connector
First release date May 27, 2015 January 9, 2017
Last update date September 2, 2015 -
Data Source VSTS REST API Analytics Service 1
Power BI Service checked checked 2
Power BI Desktop unchecked checked
Available Data
Work Items - Current state checked checked
Work Items - History checked checked
Work Items - Customization unchecked checked
Source Control - Git checked unchecked
Source Control - TFVC checked unchecked
Builds - XAML checked unchecked
Elements
Tables checked checked
Relationships checked unchecked
Measures checked unchecked
Reports checked unchecked
Dashboard checked unchecked
Power Query Functions unchecked checked
Authentication
Microsoft Account (Live ID) checked checked
Azure Active Directory (AAD) checked checked
OAuth checked checked
Personal access token unchecked checked
Alternate credentials unchecked checked
Other
Support for large accounts 3 unchecked checked
Support for custom measures unchecked checked
Support for mashup with additional data sources 4 unchecked checked

Notes:

  1. The Analytics Service is in close preview at this time.
  2. The data model is created in Power BI Desktop. Then, it can be published and refreshed in Power BI Service.
  3. There is a limit on how long a refresh operation can take before it gets terminated by the system. Using the number of work items as a proxy measure for the size of account, an account is considered "large" accounts when it has over 400k work items.
  4. Power BI Desktop allows users to load tables from different sources and combine them into a single data model (e.g. custom working days calendar).

To get started using Power BI and the Analytics service, make sure you have permissions required to access the Analytics service and then review the knowledge base of articles.