How To Connect To Azure Dev Ops Using Power BI
Tags: softwaredevelopment
Published: 2024-01-24 01:49:44

**Introduction:**

In today’s fast-paced [**software development**](https://technologycue.com.au/software-development-services-brisbane/) 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”

**![](https://technologycue.com.au/wp-content/uploads/2024/01/Picture1-300x114.png)**

**Step 2: Access My Azure DevOps Organizations**

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

**![](https://technologycue.com.au/wp-content/uploads/2024/01/Picture2-298x300.png)**

**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.”

**![](https://technologycue.com.au/wp-content/uploads/2024/01/Picture3-300x205.png)**

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

**![](https://technologycue.com.au/wp-content/uploads/2024/01/Picture4-300x236.png)**

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

**![](https://technologycue.com.au/wp-content/uploads/2024/01/Picture5-204x300.png)**

### **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.

**![](https://technologycue.com.au/wp-content/uploads/2024/01/Picture6-300x141.png)**

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

**![](https://technologycue.com.au/wp-content/uploads/2024/01/Picture7-300x166.png)**

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

**![](https://technologycue.com.au/wp-content/uploads/2024/01/Picture8-300x92.png)**

**Step 4: Successfully Obtain Data**

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

**![](https://technologycue.com.au/wp-content/uploads/2024/01/Picture9-300x230.png)**

**Conclusion:**

By following these step-by-step instructions, you can seamlessly connect [**Azure DevOps to Power BI**](https://technologycue.com.au/power-bi-consulting-brisbane/), 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.