Available data tables in the Power BI Content Pack for VSTS



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?.

To connect to the Analytics Services for VSTS 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.