Focus on how to structure and model your ADO data for effective reporting.
Includes topics like creating data models, relationships, and calculated columns.
Is a Tag Associated to a Work Item? With Azure DevOps, you can use tags to manage your work items, such as user stories, tasks, bugs, and features. Tags are words or phrases that you can attach to work items… Read More »Detect if a Tag is Associated to a Work Item in Power BI Reporting
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
Incremental Refresh in Power BI for ADO Analytics Views Ensuring that work item reports remain useful requires a performant refresh action to keep the report up-to-date with the latest work item values. Configuring the incremental refresh policy on the analytics… Read More »Configure the Power BI Incremental Refresh for Analytics Views in Azure DevOps
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
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
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