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