Setup Reporting Filtering by Tag 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 Tags
Why a Star Schema Data Model Using a star schema data model in your Power BI report to link iterations and area paths to the work items fact table offers several benefits. This schema enhances data integrity by ensuring consistency… Read More »Optimize your ADO Reports with a Star Schema Data Model in Power BI
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 »Incremental Refresh Policy for ADO Analytics Views with Historical Data
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 »Separate ADO Work Item Tags into a Table for Power BI Reporting
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
Creating a Popup Report to View the Work Item’s Long or HTML Text In a previous post, I showed how to obtain the work item’s long text or HTML to the Power BI dataset. This enables you to create a… Read More »Viewing the Work Item’s Long or HTML Text Fields in a Power BI Report
Adding Long Text and HTML 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 add… Read More »Add a Work Item’s Long Text Field Data to an Analytics View for the Power BI Report
Modifying the Analytics View’s Data to Report Visual Friendly Making the default data types from an Analytics View graph friendly means changing to a more readable format. The default data types for the fields in the analytics view are appropriate.… Read More »Transforming 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 ADO Area or Iteration Path for Easier Graph Readability
Adjusting the Analytic View and Propagating the changes to Power BI In some cases, you may need to make changes to the analytic view after establishing the initial connection. The most common scenario involves adding or removing a field from… Read More »Updating the Analytic View after it is Connected to the Power BI Data Model