Available data tables in the Power BI Content Pack for Team Services

Last Update: 3/6/2017

Team Services


Feature availability: The Analytics Service is in private preview and only available to select customers of Visual Studio Team Services at this time.

To connect to the Analytics Services for Team Services from the Power BI Desktop, you must download the Power BI Desktop January 2017 Update or a newer version. You can download it from the official Power BI Desktop download page.

The current release of the Data Connector supports custom fields added to the process references by a team project.

Currently available data

Data Details
Work Items - Current state Load current state of Work Items.
Work Items - History Load all changes that happened to work items in the last 30 days.
Work Items - Customization Load values of custom fields defined added to process templates.

Currently available tables

Table Description
Work Items - Today

Contains all Work Items. Suffix "Today" indicates that it contains one days' worth of data in contrast to Work Items - Last 30 Days table, which loads also historical data. Each column corresponds to a data field available in a work item type used in the team project.

Work Items - Last 30 Days

Similar to the Work Items - Today table in that it contains the same column-fields, however, it loads work item history for the last 30 days, which can be used to create trend reports.

It has been modelled as a periodic snapshot fact table with one day period. The grain of this table is the period, not the individual work item. What this means is that a single Work Item can appear 30 times (once per day). When working with this table you should partition the data by the Date column. Additionally, it contains a field named Is Current, which can be used instead of the Date column if you are interested in only the current state of each work item.