Skip to content

data-connector-connect.md

Latest commit

 

History

History
224 lines (152 loc) · 10.4 KB

data-connector-connect.md

File metadata and controls

224 lines (152 loc) · 10.4 KB
title Connect to Power BI Data Connector
titleSuffix Azure DevOps
description Learn how to use Power BI Data Connector to access Azure DevOps Analytics views in Power BI for creating insightful reports and dashboards.
ms.assetid 509ECCF2-E18E-4F14-B7EE-8802AB8938A2
ms.subservice azure-devops-analytics
ai-usage ai-assisted
ms.author chcomley
author chcomley
ms.topic how-to
monikerRange <=azure-devops
ms.date 12/01/2025

Connect Analytics with Power BI Data Connector

[!INCLUDE version-lt-eq-azure-devops]

Learn how to establish a seamless connection between Power BI and Azure DevOps using the Power BI Data Connector. This integration lets you extract valuable insights from your Azure DevOps data and create compelling reports and dashboards within Power BI using Analytics views.

[!INCLUDE analytics note]

The Power BI Data Connector provides a direct connection to Azure DevOps Analytics, allowing you to do the following tasks:

  • Import Analytics views into Power BI Desktop
  • Create custom reports with real-time Azure DevOps data
  • Build interactive dashboards for stakeholders
  • Track project metrics and team performance
  • Visualize work item trends and sprint progress

Prerequisites

Ensure you meet the following requirements before connecting Power BI to Azure DevOps Analytics:

::: moniker range="azure-devops"

Category Requirements
Access levels - Project member
- At least Basic access level
Permissions - Analytics permissions
- Contributors group membership provides required permissions
Tools - Azure Boards enabled
- Power BI Desktop (latest version recommended)
Preparation - Understanding of Analytics concepts
- Analytics view created for your reporting needs
- Familiarity with Power BI fundamentals

::: moniker-end

::: moniker range="< azure-devops"

Category Requirements
Access levels - Project member
- At least Basic access level
Permissions - Analytics permissions
- Contributors group membership provides required permissions
Tools - Analytics installed and enabled
- Azure Boards enabled
- Power BI Desktop (latest version recommended)
Preparation - Understanding of Analytics concepts
- Analytics view created for your reporting needs
- Familiarity with Power BI fundamentals

::: moniker-end

[!INCLUDE alt-creds-deprecation-notice]

Create a new report and connect to Azure DevOps

Follow these steps to create a new Power BI report and establish a connection to your Azure DevOps Analytics data:

  1. Open Power BI Desktop and create a new report:

    • Launch Power BI Desktop on your computer
    • If the startup screen appears, select Get data
    • If you're already in Power BI Desktop, select Home > Get Data from the ribbon

    :::image type="content" source="media/data-connector/get-data-splash-screen.png" alt-text="Screenshot of Power BI Desktop with Get data option highlighted on the startup screen and Home ribbon.":::

  2. Find the Azure DevOps connector:

    • In the Get Data dialog, select Online Services
    • Look for your Azure DevOps instance
    • Select the appropriate connector and then select Connect

    If you don't see the Azure DevOps connector in the Online Services category:

    • Ensure you have the latest version of Power BI Desktop installed
    • Search for "Azure DevOps" in the search box at the top of the Get Data dialog
    • Look in the Other category if it's not in Online Services

    :::image type="content" source="media/data-connector/get-data-azure-devops.png" alt-text="Screenshot of Power BI Get Data dialog with Online Services selected and Azure DevOps (Boards only) connector highlighted.":::

[!INCLUDE connect to an analytics view]

Create reports and dashboards

After successfully loading your Analytics data, you can create various reports and visualizations:

Get started with report creation

  1. Explore your data: Review the imported fields and understand the data structure
  2. Plan your visualizations: Identify key metrics and KPIs you want to track
  3. Create initial reports: Start with simple charts and gradually add complexity
  4. Test and iterate: Validate your reports with stakeholders and refine as needed

Common report types

  • Work item trends: Track bug reports, user stories, and feature progress over time
  • Sprint burndown charts: Monitor sprint progress and team velocity
  • Team performance metrics: Analyze throughput, cycle time, and completion rates
  • Backlog analysis: Visualize work distribution and priority alignment

For detailed examples and templates, see Example reports based on Analytics views.

:::image type="content" source="media/data-connector-visual.png" alt-text="Screenshot of Power BI Desktop showing an Analytics-based report with various charts and metrics." lightbox="media/data-connector-visual.png":::

Best practices

To get the most out of your Power BI and Analytics integration:

Performance optimization

  • Filter your Analytics views to include only necessary data
  • Use appropriate date ranges to limit data volume
  • Refresh data regularly but avoid excessive refresh frequency
  • Consider data refresh schedules that align with your reporting needs

Report design

  • Start simple and add complexity gradually
  • Use consistent formatting and branding across reports
  • Include context and explanations for metrics
  • Test with different user personas to ensure usability

Data governance

  • Document your Analytics views and their purposes
  • Establish data refresh policies and ownership
  • Monitor report usage and performance
  • Maintain security and access controls

Troubleshooting

Common error scenarios

Azure DevOps connector not visible

Issue: Can't find "Azure DevOps" in the data source list in Power BI Desktop

Possible causes and solutions:

  1. Outdated Power BI Desktop version:

  2. Looking in the wrong category:

    • Check Online Services category first
    • If not found, search for "Azure DevOps" using the search box
    • Try looking in the Other category as a fallback

  3. Regional availability:

    • Ensure your Power BI region supports the Azure DevOps connector
    • Contact your administrator if using Power BI through organizational licensing

  4. Power BI licensing:

    • Verify you have appropriate Power BI licensing
    • Some connector limitations might apply based on licensing tier

Query result exceeds maximum size

Error message: "Query result exceeds maximum size. Reduce the number of records by applying more filters"

Cause: Your Analytics view returns more than 250,000 records.

Solutions:

  1. Reduce the time range in your Analytics view
  2. Apply more filters to limit work item types or states
  3. Use multiple smaller views instead of one large view
  4. Consider aggregating data at a higher level

:::image type="content" source="media/QueryExceedsPreferredMaxSizeException.png" alt-text="Screenshot showing query size limit error with suggested resolution steps.":::

Access denied or authentication errors

Error message: "The user is not authorized" or authentication failures

Possible causes and solutions:

  • Check project permissions: Verify you have access to the Azure DevOps project
  • Validate Analytics permissions: Ensure you have Analytics access
  • Review credentials: Work with your administrator for credential issues
  • Microsoft Entra authentication: Verify your account is properly configured

:::image type="content" source="media/AccessDeniedError.png" alt-text="Screenshot showing authentication error with troubleshooting guidance.":::

Analytics access forbidden

Error message: "Access to the resource is forbidden"

Resolution: Contact your project administrator to grant View analytics permission. See Analytics security for details.

:::image type="content" source="media/AnalyticsAccessCheckException.png" alt-text="Screenshot showing Analytics access forbidden error.":::

Project not found

Error message: "Project 'X' does not exist or you do not have permissions to access it"

Common causes:

  • Incorrect project name: Ensure you're using the project name, not the team name
  • URL confusion: For https://dev.azure.com/fabrikam/MyProject/MyTeam, use "MyProject" not "MyTeam"
  • Missing permissions: Verify you have access to the specified project

:::image type="content" source="media/ProjecNotFoundError.png" alt-text="Screenshot showing project not found error with explanation of project vs team names.":::

Reading error messages

When you troubleshoot Power BI Data Connector issues, do the following tasks:

  1. Look for the root cause: Search for [DataSource.Error] in the error message
  2. Ignore wrapper text: Focus on the core error description
  3. Check suggested actions: Error messages often include resolution steps
  4. Verify prerequisites: Ensure all requirements are met

Related content