Covers methods to extract data from ADO into Power BI.
Includes using OData queries, Analytics Views, and the Azure DevOps Data Connector
Azure DevOps OData Reporting Azure DevOps OData Reporting provides an easier alternative to Analytics Views while maintaining a similar reporting experience in Power BI. One of the most common questions when moving away from Azure DevOps Analytics Views is how… Read More »Azure DevOps OData Reporting Without Analytics Views
Azure DevOps OData Reporting vs Analytics Views Azure DevOps Reporting using OData can open up many opportunities when creating reports in Power BI. The Azure DevOps product group is encouraging users to utilize Analytics Views for your Power BI reports.… Read More »OData vs Analytics Views: Which Should You Use?
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 Parameterizing OData queries in Power BI reports and Fabric Dataflows makes it much easier to reuse the same solution across multiple Azure DevOps team projects. This is especially helpful when building an organizational reporting model where… 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