Feature availability: The Analytics Service is in preview and only available to select customers of Visual Studio Team Services at this time.
Gain insight and analyze the progress and quality of your project by connecting Power BI to the data collected and stored in Team Services. 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.
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 Team Services 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 Team Services 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||Team Services REST API||Analytics Service 1|
|Power BI Service||2|
|Power BI Desktop|
|Work Items - Current state|
|Work Items - History|
|Work Items - Customization|
|Source Control - Git|
|Source Control - TFVC|
|Builds - XAML|
|Power Query Functions|
|Microsoft Account (Live ID)|
|Azure Active Directory (AAD)|
|Personal access token|
|Support for large accounts 3|
|Support for custom measures|
|Support for mashup with additional data sources 4|
- The Analytics Service is in preview and only available to select customers of Visual Studio Team Services at this time.
- The data model is created in Power BI Desktop. Then, it can be published and refreshed in Power BI Service.
- 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.
- 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).