Create Power BI dashboards and reports

VSTS

Important

We are deprecating the Power BI.com Visual Studio Team Services (VSTS) Content Pack on November 15, 2017 primarily due to the negative impact it has had on VSTS accounts, including throttling end users access. Support will continue for all existing Power BI.com data sets based on the Content Pack. However, you won’t be able to create any new data sets.

The Analytics Marketplace extension and upcoming updates to the Power BI Desktop connector for VSTS are intended to replace and improve on the capabilities of the Content Pack. While the Analytics Marketplace extension currently supports Work Item Tracking data, we will update it to support additional data types including Tests, Build, Release and Version Control. In the interim, you can use VSTS REST APIs as an alternative to the Content Pack to report on these additional data types.

You can create dashboards, individual reports, or explore data collected for your VSTS account once you connect to Power BI. As the Power BI data model for VSTS grows to include more features you'll have access to more advanced reporting. As Power BI is upgraded, it will provide you with additional visualizations and capabilities over time without any upgrades.

Prior to working with VSTS data, review Power BI - Guided Learning.

Get started

After getting connected to VSTS you will see an initial dashboard. On the left side of the screen you will notice Dashboards, Reports and Datasets.

Dashboards, Reports and Datasets

These are related in the following way: Dashboards contain charts that are based on Power Q&A or charts contained in a report. Reports contain charts based on data contained in the dataset.

Currently, a report can be based on a single dataset. You can create as many reports based on a dataset as you want. Dashboards can contain charts from one or more reports or Power Q&A questions.

Note

Consider renaming the dataset, report and dashboard immediately after the data finishes loading. Every time you click Get Data, new data is imported with the name "VSTS" and another dataset, report and dashboard is created. This can become confusing very quickly.

A good habit is to rename the datasets based on either the account or the project name. For example, using Fabrikam as the account or Fabrikam.projectA to differentiate a project will make using Power BI much easier.

Work with datasets

Refer to Get started with Power BI for information on working with datasets.

Work with reports

Reports are at the heart of Power BI and provide the basis for dashboards. Dashboards are the shareable component of Power BI. See the Power BI documentation on Reports for more information.

Understand the default report

The VSTS content pack generates a single report with several pages.

Report page Description
Open Bug Status This is a general bug status report which is applicable to all three of the out-of-the-box processes (Agile, CMMI, and Scrum. All charts exclude closed bugs (State=Closed or Done).
Git Activity Provides source control file information for a team project created to use Git. Report pages show data from the last 30 days only.
(Team Foundation) Version Control Provides source control file information for a team project created to use Team Foundation version control (TFVC).
Builds (Xaml) Information related to automated builds. This does not include the latest build engine released with TFS 2015 (formerly Build v.Next).
Agile Project Status * basic report that details data pertinent to a team project created with a version of the Agile process.
Scrum Project Status * basic report that details data pertinent to a team project created with a version of the Scrum process.
CMMI Project Status * A basic report that details data pertinent to a team project created with a version of the CMMI process.
Pull Requests Provides information related specifically to pull requests for a team project created to use Git.

* Delete any project status report pages that don't apply to your particular situation and update the dashboard as appropriate.

Edit the default report

For information on how to edit the default report, see the Power BI documentation.

Work with Dashboards

For help in creating and managing Dashboards, see the Dashboards in the Power BI service.