Covers methods to extract data from ADO into Power BI.
Includes using OData queries, Analytics Views, and the Azure DevOps Data Connector
The Use Case for Finding Users Assigned to Work Items A customer faced an issue where an employee who had left the company was deactivated in Active Directory (AD). They needed to identify all the work items assigned to this… Read More »How to Find the User Assigned to Work Items
Parameterize the ODATA Queries To parameterizie ODATA queries in Power BI reports or Fabric dataflows simplifies the replication process across team projects, which is particularly useful when creating an ADO organizational data model. These queries must be executed at the… Read More »How to Parameterize the ODATA Queries in Power BI
Why Include the Iteration, Area Path, and Other Fields to the ODATA Query The Azure DevOps Analytics Views offer direct access to fields like iteration, area path, project name, and user name within the dataset for reporting purposes. However, incorporating… Read More »Include Iteration and Area Path to an ODATA Query
Visualizing ADO Workitems in a Hierarchial Data Model To effectively visualize the hierarchical structure of work items in Azure DevOps (ADO) within Power BI, you need to create a data model that mirrors ADO’s inherent structure. This involves linking work… Read More »Visualizing ADO Workitems: Epics to Tasks with Rollup Metrics
Create Work Item Rollup Calculations with a Hierarchy Data Model in Power BI Generating reports on Azure DevOps (ADO) work items in Power BI can be quite challenging, especially when dealing with hierarchical relationships. ADO’s current reporting capabilities only support… Read More »Easily Create a Work Item Rollup Calculations Report
Creating an Incremental Refresh Policy in Power BI for Analytics Views Containing Historical Data If you are using azure DevOps Analytics Views (AV) to create Power BI reports and dashboards, you might have encountered some challenges with the size and… Read More »Implementing an Incremental Refresh Policy for Analytics Views with Historical Data
Efficient Workflow for Writing ODATA Queries The Azure DevOps documentation for writing ODATA queries and adding to the Power BI report advises you combine the ODATA query to a single line when adding to the Power BI report. This is… Read More »Best Practices for Writing OData Queries for Azure DevOps Reporting
A guide to securely and efficiently connect the Power BI Service to SQL Server with a service principal. A service principal is useful for accessing SQL Server from the Power BI Service as it is an identity that represents an… Read More »Connect Power BI Services to SQL Server with a Service Principal
Create an Enterprise Dataset for Multiple Team Projects ADO users commonly write work item queries to construct dashboards or export data to Excel for reporting. Converting these queries into analytic views as the primary source of reporting on work items… Read More »Create an Enterprise Azure DevOps Report with Analytics Views
Using an Analytics View as the Source for your ADO Report The simplest way to start reporting with Power BI is to use an Analytics View as the source for Azure DevOps work items. Analytics Views are easy to create… Read More »Creating an Analytics View and Connecting to a Power BI Report
The Benefits of Using Analytics Views for Power BI Reporting In the ever-evolving landscape of software development, the necessity to promptly and comprehensively monitor project progress is paramount. The integration of Azure DevOps with Power BI reporting, specifically through the… Read More »A Guide to Seamless Power BI Reporting with Azure DevOps Analytics Views