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
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
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
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
Clean and Transform the Analytic View’s Data to make it Visual Friendly Making the default data types from an Analytics View graph friendly means changing to a more readable format. Most of the default data types for the fields in… Read More »Clean and Transform the Analytics View’s Data
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
Adjusting the Analytic Views and Propagating the changes to Power BI In some cases, you may need to make changes to the analytic views after establishing the initial connection. The most common scenario involves adding or removing a field from… Read More »Make Changes to the Analytic Views after using in a Report
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