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
Why Display the ADO Sprint Status on a Power BI Report Analytics Views (AV) provide the iteration start and end dates and the full path. It does not provide a field to show the past, future, or current iteration like… Read More »How to Display the ADO Sprint Status in a Power BI Report
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
Find a Custom Work Item Field Azure DevOps work item templates offer the flexibility to customize by adding new fields, allowing teams to tailor the platform to their specific software processes. These newly added fields will automatically appear in the… Read More »How to Find a Custom Work Item Field in ODATA
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
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
Optimize the Power BI Report with a Star Schema Data Model using Analytic Views or ODATA Using a star schema data model in your Power BI report to link iterations and area paths to the work items fact table offers… Read More »Optimize your ADO Reports with a Star Schema Data Model in Power BI
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