Data EngineerMicrosoftMS AzurePower BIPowerBI Tips

How to Connect to Azure Dev Ops using Power BI

By 23/01/2024 No Comments

How to connect to Azure Dev Ops using Power BI

 

Introduction:

In today’s fast-paced software development landscape, the ability to analyze and visualize data from Azure DevOps is crucial for making informed decisions. One powerful tool for this purpose is Microsoft Power BI, which allows you to create interactive reports and dashboards. In this step-by-step guide, we will walk you through the process of connecting Azure DevOps to Power BI in two different ways for efficient data analysis.

 

First Way

 

Step 1: Log in to Microsoft Azure

Start by logging in to Microsoft Azure using your account information. Once logged in, navigate to the main screen. Click on “Azure DevOps organizations”

Step 2: Access My Azure DevOps Organizations

Select “My Azure DevOps Organizations” to enter the home of Azure DevOps.

Step 3: Connect to Power BI Desktop

In Power BI Desktop, go to “Get Data,” choose “Online Services,” and then select “Azure DevOps (Boards only).” Click on “Connect.”

Step 4: Select Organization and Project

Return to the Azure DevOps main interface, click on the organization you want to obtain data from, and note the organization name and project name. These will be required in Power BI Desktop.

Step 5: Complete the Operation in Power BI Desktop

Go back to Power BI Desktop, enter the organization and project names, and click “OK” to retrieve the data you need. Your first data connection is now established.

 

Second Way

 

Step 1: Access Azure DevOps Organizations (URL Linking)

Follow a similar process to access Azure DevOps Organizations but use URL linking, particularly effective for Owner-level Organizations.

Step 2: Copy URL from Projects

Navigate to the Projects section and copy a portion of the URL. This URL will be used in the Power BI connection.

Step 3: Connect via OData Feed in Power BI

In Power BI, select “Get Data,” choose “Other,” and then opt for “OData Feed.” Paste the copied URL, ensuring to replace the highlighted section with the URL from Azure DevOps.

Step 4: Successfully Obtain Data

After clicking OK, you have successfully obtained relevant data from Azure DevOps using the URL linking method.

Conclusion:

By following these step-by-step instructions, you can seamlessly connect Azure DevOps to Power BI, enabling you to create insightful reports and dashboards. This integration enhances your ability to analyze project data and make data-driven decisions, ultimately contributing to the success of your software development endeavors.

Leave a Reply