Options to Select the Data Model for Azure DevOps Reporting When it comes to data reporting, particularly with Power BI for visualizing Azure DevOps data, selecting the right Power BI data model for Azure DevOps reporting is crucial. A well-chosen… Read More »Learn How to Select the Data Model for Azure DevOps Reporting
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
Easily Create a Single Table Data Model for Effective Reporting To create an effective ADO report, you don’t need a complex data model if your goal is to provide summary information. Using an Analytics View is the easiest way to… Read More »Easily Create a Single Table Data Model Report
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
Filter Work Items by Tags Creating a report in Power BI using work items from Azure DevOps (ADO) offers a powerful way to visualize and analyze project data. One particularly effective feature is the ability to filter work items by… Read More »Filter Work Items by ADO Tags in Power BI
Your ADO organization probably generates a high number of work items and Power BI is an excellent reporting tool to help visual and track the work your team is assigned for an iteration. When creating Power BI reports using work… Read More »Search by Work Item ID in the Power BI Report
Tags are useful for categorizing and filtering work items in Azure DevOps. However, when you want to create Power BI reports based on the tags, you may encounter some challenges. For example, how can you count the number of work… Read More »How to create a workitem tags table with Power BI
Creating a Popup Report to View the HTML or Long text field from a Work Item In this blog post, I showed how to obtain the work item’s long text or HTML to the Power BI dataset. This enables you… Read More »View the HTML or Long Text Fields from a Work Item in a Power BI Report
Add the HTML and Long Text Fields to Analytics Views and ODATA Queries in Power B To add the HTML and long text fields to an existing Analytic View or ODATA query in the Power BI report, you need to… Read More »Add the HTML and Long Text fields from a Work Item to an Analytics View
Quickly Open the ADO Work Item to view the Details from a Power BI Report Opening the ADO Work Item to view the details from a Power BI report is one of the most useful reporting. The users want to… Read More »Learn how to Open the ADO Work Item the Power BI Report
Steps to Make the Area and Iteration Path Easier to View In some Azure DevOps projects we see long string values for Iteration Path due to nesting of iterations under common parent iteration. This long string value is not friendly… Read More »Shorten the Area Path and Iteration for Easier Graph Readability