Power BI integration overview

VSTS

Our Power BI integration makes getting the data into Power BI easy, so you can focus on creating amazing Power BI reports!

VSTS supports three ways to pull data from VSTS into Power BI:

Connection Option Description
Connect using the VSTS Data Connector The VSTS Data connector is the recommended way to connect Power BI to VSTS. The connector simplifies the VSTS data model into a single table and models historical data to simplify trend reporting. The VSTS Power BI Data connector works with Analytics Views. Last updated February 4th, 2018
Connect to VSTS using the Power BI OData connector Using the Power BI OData connector is not recommended for anything other than analysis of current work items. The VSTS data model has relationships and advanced filters which are necessary for many scenarios and are not supported using the OData connector
Connect using VSTS functions Intended for advanced users who need a greater degree of control of what data is included in the model. Using the functions, you can specify OData queries as well as combine data from other sources, such as VSTS REST APIs. You can also support complex model structures not supported by the VSTS Data Connector. Last updated February 4th, 2018

Prerequisites

Before you get started using Power BI with VSTS, make sure you have completed the following steps:

  1. Install the Power BI Desktop February 2018 Update or a newer version. You can download it from the official Power BI Desktop download page.

  2. Install the VSTS Analytics extension.

  3. Configure the permissions required to access the Analytics service.

  4. Review the knowledge base of Power BI articles.

  5. If you are not familiar with the VSTS Analytics Service, we recommend you read "What is the Analytics Service" before continuing.

Deprecated PowerBI.com Content Pack

In November, 2017 we deprecated the PowerBI.com Visual Studio Team Services (VSTS) Content Pack. We deprecated it due to the negative impact it had on the performance of VSTS organizations, including throttling end users access. Support will continue for all existing PowerBI.com datasets based on the Content Pack; however, you won't be able to create any new datasets.