Power BI integration overview


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

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

  1. Install the Power BI Desktop January 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

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. Last updated January 8th, 2018
Connect to VSTS using the Power BI OData feed Using the default Power BI OData feed for VSTS is not recommended for anything other than analysis of current work items. The VSTS data model has relationships and advanced filters that are not possible using the default OData feed which are necessary for more complex scenarios
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 January 8th, 2018

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 has had on VSTS accounts, including throttling end users access. Support will continue for all existing PowerBI.com data sets based on the Content Pack. However, you won’t be able to create any new data sets.