About Power BI integration

Azure DevOps Services | Azure DevOps Server 2019

Power BI is a suite of business analytics tools. Use it to do ad hoc analysis, produce beautiful reports, and publish for enterprise consumption.

Note

Power BI integration is in preview for Azure DevOps Services.

If you are looking for how to use Power BI, see Power BI documentation.

To access Analytics views, you must enable the feature as described in Enable preview features.

Note

Power BI integration is in preview for Azure DevOps Server 2019. If you are looking for how to use Power BI, see Power BI documentation.

The easiest way to pull Azure DevOps data into Power BI is to use the Power BI Data Connector. The Azure DevOps Power BI Data connector works with Analytics views. For more information, read What are Analytics views.

Power BI Azure DevOps Connector (Beta)

Power BI Azure DevOps Server Connector (Beta)

Support data connection methods

You can pull data from the Analytics services into Power BI in one of three ways.

Connection Option Description
Connect using the Azure DevOps Data Connector The Azure DevOps Data connector is the recommended way to connect Power BI to the Analytics service. The connector simplifies the data model into a single table and models historical data to simplify trend reporting. The Azure DevOps Power BI Data connector works with Analytics views. Last updated February 4th, 2018
Connect 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 Analytics service data model has relationships and advanced filters which are necessary for many scenarios and are not supported using the OData connector
Connect using Azure DevOps functions This option is 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 Azure DevOps REST APIs. You can also support complex model structures not supported by the Azure DevOps Data Connector. Last updated February 4th, 2018

Prerequisites

Before you get started using Power BI to work with the Analytics service, make sure you have completed the following steps:

  1. Install the Power BI Desktop October 2018 Update or a newer version. You can download it from the official Power BI Desktop download page.
  2. Configure the permissions required to access the Analytics service.
  3. Review the knowledge base of Power BI articles.
  4. If you are not familiar with the Analytics service, read "What is the Analytics service" before continuing.
  1. Install the Power BI Desktop October 2018 Update or a newer version. You can download it from the official Power BI Desktop download page.
  2. Install the 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 Analytics service, read "What is the Analytics service" before continuing.

Deprecated PowerBI.com Content Pack

In November, 2017 we deprecated the PowerBI.com Azure DevOps Content Pack. We deprecated it due to the negative impact it had on the performance of 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.