Integration of PowerBI with VSTS

tudip-logo

Tudip

12 July 2019

What is PowerBI?

PowerBI is a Microsoft based business analytics tool which is used to reflect the data into the form of graphical representation such as live dashboards and reports.

Importance of PowerBI

  • PowerBI provides the feature to fetch the latest data from the Data resources using “Refresh” functionality.
  • After publishing the PowerBI file you can view it in the Web browsers and Mobile devices.
  • PowerBI contains different visualizations which are used to display graphs using Filters and Values. Also, you can edit your queries which are fetched from the Data resources

Integration of PowerBI with the VSTS

This integration will convert the organizational VSTS data into the PowerBI graphical dashboards and reports.

Requirements

  • An account in VSTS (Visual Studio Team Services)
  • Latest PowerBI desktop tool.
  • Analytics permission for VSTS account.
  • Analytics extension in VSTS.

Creating Analytics Views from the VSTS

  • Search the “VSTS login” in Google search.

vsts-login

  • Click on the highlighted VSTS link.
  • Click on “Sign in” on the home page of the VSTS.

Sign-in-to-Azure-Devops

  • Enter Microsoft online email, select “Work or school account” option, enter the password and click on the Sign button of the VSTS. (VSTS-Sign-In-Page)

sign-in

  • Go to the Main project of Organization of the VSTS.
  • Install the “Analytics” extension from the Organisation settings.

Analytics

  • Set the “Analytics views” edit, view and delete a permission from the VSTS Admin account.

View-Analytics

VSTS-Permissions

  • Go to “Analytics Views” from the VSTS Main menu.

Analytics-Views

  • Click on “New Views” button.
  • Enter the details for General tab like Name, Description and sharing option.

VSTS-General

  • In “Work Items” tab select the “Filter by team”, “Main” project as “All teams”.

filter-by-team

  • Include all the fields from VSTS using “Customise the field selection” in the Fields tab.

Fields

  • In the History tab, select the period of the data from the VSTS.

history-current-only

  • Complete the Verification and save the settings.

verification

  • The view will be created in the VSTS. (For Eg. name of the view is “PowerBI view”)

all-history-of-vsts

The connection of VSTS to PowerBI

  • Download the latest PowerBI desktop tool.

Download-Power-BI-Desktop-App

Power-BI

  • Open the PowerBI desktop tool and click on the “Get Data” option.

Power-BI-Get-Data

  • Select “Azure DevOps (Beta)” from the Online services and click on Connect.

Online-Services

  • Click on the “Continue” button for “Preview Connector” popup.

Preview-Connector

  • Consider the Organization name “ash-tech-inc” from the URL, if the Organization URL is “https://dev.azure.com/ash-tech-inc./”.

Azure-Services-Team-Project

  • Consider the Team Project name as “Ash-Tech” from the URL, if the Organization URL is “https://dev.azure.com/ash-tech-inc./Ash-Tech”.

Azure-Devops-project

  • Click on the “Ok” button and the user will be redirected to the Azure DevOps Sign in the popup.

Organizational-Account

  • Click on Sign in and enter the “Azure DevOps” credentials. (Please make sure that user’s VSTS account have permission to the Project)

Organizational-Account

  • After a successful Sign in, click on connect and you will be redirected to the “Analytics View Popup”.
  • Select the display option “PowerBI view” which we created in VSTS.

Power-BI-Load

  • Click on the Load button and VSTS data loading will start.

load-Power-BI

  • Based on the data size it will take the required time and User will be able to see the VSTS fields which are used while creating Product Backlogs, Tasks and Bugs.

Count-of-Area-Path

Request a quote