Focuses on creating and customizing visualizations in Power BI and this includes dashboards, reports, and visual best practices.
Create the Team Project Report in Excel Export Azure DevOps Team Projects to Excel using the OData endpoint is an easy and efficient way to generate detailed reports. This method lets you view key information such as Team Project ID,… Read More »How to Export Azure DevOps Team Projects to Excel
Generating a report of users from Azure DevOps (ADO) using Excel via the ODATA endpoint is a straightforward method to view user details, including their login names and the last time their information was updated. Excel serves as an excellent… Read More »How to Export Azure DevOps Users to Excel
Create an ADO Work Item Progress Report with Analytics Views Enhance your team’s project management by using Analytics Views and Power BI to track the status of child work items, such as user stories or tasks. The ADO work item… Read More »How to Create an ADO Work Item Progress Report
Why Display the ADO Sprint Status on a Power BI Report Analytics Views (AV) provide the iteration start and end dates and the full path. It does not provide a field to show the past, future, or current iteration like… Read More »How to Display the ADO Sprint Status in a Power BI Report
How to Get Started with Azure DevOps Reporting using Power BI If you’ve found this blog, it’s likely because you’ve encountered the constraints of reporting within Azure DevOps (ADO). While ADO is sufficient initially, as your team or organization evolves… Read More »How to Get Started with Azure DevOps Reporting
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
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
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
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