What is available in the Power BI Content Pack for Team Services

Last Update: 3/6/2017

Team Services

Power BI Content Pack for Visual Studio Team Services gathers data from different feature areas and combines them into a single coherent analytical model.

Currently available data

Data Details
Work Items Current state, trend data, and rollup
Builds XAML builds including build requests, queues and details
Source Control - Git Commits, repositories, pull requests
Source Control - TFVC Changesets, files, file changes and branches

Timeline for new data availability

Data Timeframe
Test Results TBD
Work Item - Kanban TBD
Work Item - trend data and rollup September 2, 2015
Work Item - Current State July 22, 2015
Builds - XAML June 24, 2015
Source Control - Git May 27, 2015
Source Control - TFVC May 27, 2015

Work with the data model

The data model has several different sets of tables related to main feature areas. These tables are described here along with their basic measures.

General purpose

Table Description
Dataset details Contains information on when the data in Power BI was last updated and the version of the Visual Studio Team Services connector data model being used.
Dates Relates to pull requests (Create Timestamp) and work items (Created Timestamp).
Projects Allows you to determine which project code check-ins and pull requests happened as well as serving as a filter against all work items.
Users Detailed user information for use with work items, pull requests, changesets and commits.

Team Foundation version control

Table Description
Branches Information on branches, including branch count.
Changesets Information on changesets including (but not limited to) measures such as the count of changesets, changesets in the last 30 days, count of changesets by a given author.
File Changes The type of change made against the file (add, change, delete) and associated measures.
Files File path and extension information on checked-in files.

Git

Table Description
Commits Information on commits such as the number of files added/deleted/edited, number of projects with commits and commit counts.
Pull Requests Information on pull requests including age, count, authors and status.
Repositories Information on the repos per project including name, count and by growth and commits.

XAML Builds

Table Description
Xaml Build Definitions Build definitions including how the build is triggered.
Xaml Build Queues Information build queues including if they are enabled and their status.
Xaml Build Requests Information on build requests including build duration, percentiles, number of builds, how long the builds were queued for and retry reasons if the build failed.
Xaml Builds All of the details regarding a build. This includes builds that failed and passed, error codes and messages, build quality and build durations.

Work Items

All individual work item tables have the following measures:

  • Count of work items. This column name is the same as the table name. For example the Bugs table has a measure called "Bugs".

Other tables may include measures specific to that work item type.

Table Description
Parent Bugs Contains information relating to bugs and includes Effort, Original Effort, Remaining Work, Size and Story Points values.
Parent Change Requests Contains information relating to Change requests and includes the Original Estimate value.
Parent Features Contains information relating to Features and includes Business Value, Days Past Target and Days Until Target values.
Parent Issues Contains information relating to Issues and includes the Original Estimate value.
Parent Product Backlog Items Contains information relating to Product Backlog Items and includes Business Value and Effort values.
Parent Requirements Contains information relating to Requirements and includes Original Estimate and Size values.
Parent User Stories Contains information relating to User Stories and includes the Story Points value.
Work Items This table contains all work items, regardless of type. Work items in any table can be filtered or sub-divided by values in this table. The Work Items count in this table is an overall count and can be broken down using the Work Item Type field. This table contains all of the System.* fields.