Project Reporting Part 3 – Reporting with Power BI for Azure DevOps

If you use Azure DevOps to manage your project and you need to do complex visualisation of project delivery statistics, you can now use Power BI for Azure DevOps using the Analytics Service.

Project Reporting Part 1 – Crucial Contribution Project Team Makes in Reporting
Project Reporting Part 2 – Why Report on Delivery Data with Power BI

Power BI for Azure DevOps

Power BI for Azure DevOps allows you to directly pull data from Azure DevOps (formerly Visual Studio Team Services) into Power BI and construct complex report visualisations using Power BI. The integration is based on Analytics Service, which is a reporting platform exposing a concise data model over Azure DevOps. There are multiple connection options. In this blog post we focus on connecting Azure DevOps with the Azure DevOps Data Connector.

Azure DevOps Data Connector

  • On the client machine you plan to develop the project reporting, you will need to download Power BI for Desktop.
  • In the Azure DevOps instance, install the Analytics Marketplace Extension¬†to your selected Azure DevOps organisation to enable the Analytics Service.

reporting03-analyticsextension

  • Fire up Power BI Desktop and go to “Get Data” and select “Azure DevOps” (at the time of writing this connector is still in beta preview).

reporting03-getdata

  • Enter the names of the Azure DevOps organization and Team project to connect to
    Organization: This is the name of your organisation as appeared in your Azure DevOps URL https://<organisation name>.visualstudio.com.
    Team Project: name of the Team Project, which usually appear as part of the URL https://<organisation name>.visualstudio.com/<Team Project Name>.
    If it asks you for credentials you will need to enter the credentials you used to connect to Azure DevOps organisation.

reporting03-orgteamprojectconnector

  • Once connected successfully, you should see the default Analytics View preloaded when you install Analytics Marketplace extension, and also any additional customised Analytics views you created in Azure DevOps. Clicking “Load” will pull the data exposed in the Analytics View into Power BI for you to use in the report.

reporting03-analyticsviewdisplay1

reporting03-analyticsviewdisplay2

Analytics View

Data available and exposed for you to use in Power BI are provided via Analytics Views. There are default Analytics View preloaded when you installed Analytics extension to your Azure DevOps organisation, but you can also build your own Analytics Views to suit your needs.

In your Azure DevOps Team Project, go to “Analytics View” section. You can build your own view by following several steps – define your work items, select your fields, decide whether you want to include all historical data, and let the service verify before exposing this view to Power BI. You can find a detailed explanation of all the options here.

To build my own “All Work Items” Analytics View, I shall pull all historical data on Bugs, User Stories and Tasks.

reporting03-analyticsviewstep1

reporting03-analyticsviewstep2

reporting03-analyticsviewstep3

In the next post we focus on some of the basic design guidelines for Power BI reports and the Azure DevOps data model exposed by the Analytics views.

Advertisements

4 thoughts on “Project Reporting Part 3 – Reporting with Power BI for Azure DevOps

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s