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

The Analytics service is generally available for all organizations using Azure DevOps Services. It provides several advanced widgets.

Power BI integration and access to the OData feed of the Analytics Service are in Preview. It is supported for use in production. We encourage you to use it and provide us feedback. As we add features, we will post them on the Microsoft DevOps Blog.

If you are looking for information about Azure Analysis Services, see Azure Analysis Services.

Note

The Analytics service is in preview for Azure DevOps Server 2019. While in preview, it is available to everyone free of charge. We encourage you to use it and provide us feedback. As we add features, we will post them on the Microsoft DevOps Blog.

You access Analytics by enabling or installing it for a project collection. The Analytics service provides several advanced widgets, Power BI integration, and access to the OData feed.

If you are looking for information about Azure Analysis Services, see Azure Analysis Services.

Supported data connection methods

You can pull data from Analytics into Power BI in one of three ways. It is important to understand each method, before choosing.

Connection Option Description Considerations
Connect using the OData queries Power BI can execute OData queries. OData queries are very powerful and can filter and aggregate data before returning it to Power BI. This is the recommended method, except for simpler reports on Boards data. It requires you to write OData queries, which is similar to writing SQL queries. Fortunately, we provide several sample reports to help you get started.
Connect using the Azure DevOps Data Connector The Azure DevOps Data connector works with Analytics views. To access Analytics views, you must enable the feature as described in Enable preview features This connector only works with Boards data (work items) and does not support other data types, such as Pipelines. It provides a flat-list of work items, and does not support work item hierarchies. At this point, we have no plans to update the connector to support other types of data. We recommend using OData queries unless you have a simpler report on Boards data
Connect using the Power BI's OData Feed connector Power BI provides an OData Feed connector that allows you to connect to and browse the Analytic's OData endpoint. This is the typical way Power BI interacts with OData feeds. You can browse and select the entities and use its Query Editor to filter the dataset. Only use this method if you have a small account. This method does not support server-side query folding. All filters are applied client-side. This means all the data is pulled into Power BI before applying the filters. If you have a small account, this may work just fine for you. However, if you have a large account, then you will likely experience long refresh times and timeouts.

Prerequisites

Before you get started using Power BI to work with Analytics, 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 Analytics.
  3. Review the knowledge base of Power BI articles.
  4. If you are not familiar with Analytics, read "What is Analytics" 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. Enable or install the Analytics extension.
  3. Configure the permissions required to access Analytics.
  4. Review the knowledge base of Power BI articles.
  5. If you are not familiar with Analytics, read "What is Analytics" before continuing.