Create Power BI dashboards and reports

Last Update: 3/28/2017

Team Services

You can create dashboards, individual reports, or explore data collected for your Team Services account once you connect to Power BI. As the Power BI data model for Team Services 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 Team Services data, review Power BI Preview - basic concepts.

Get started

After getting connected to Team Services 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 "Team Services" 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 Visual Studio Team Services 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 Ddashboardss, see the Power BI documentation.