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.
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.
- 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).
- 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.
- 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.
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.
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.