Improving Data Insights with Time Intelligence Integrating a date table in Power BI is essential for generating reports that offer a thorough analysis of work items, pipelines, and testing in Azure DevOps (ADO). A date dimension is a table featuring… Read More »Integrating a Date Table for Time Intelligence for Azure DevOps Reporting
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
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 »Check for Tags Associated to a Work Item in a Power BI Report
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
A guide to securely and efficiently connect the Power BI Service to SQL Server with a service principal. A service principal is useful for accessing SQL Server from the Power BI Service as it is an identity that represents an… Read More »Connect Power BI Services to SQL Server with a Service Principal
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
Quickly View the Work Item’s Details from a Power BI Report Opening the Azure DevOps Work Item to view the details from a Power BI report is one of the most useful reporting. The users want to see the data… Read More »Add URL Link to Open the Work Item in ADO from a Power BI Report