Azure DevOps is built around the pattern than items have child items and so a backlog view will show the items in a hierarchy. When the work items some into Power BI that is not shown. So this gives me the chance to use one of my favourite resources, DAX Patterns and their Parent-Child pattern.
Azure DevOps is full of data that management want to to report on. Adding a Power BI report is an obvious way to do this. This post is my take on how I would build the reports.
One of the easiest ways to edit a project in Azure DevOps is to connect Excel to the project. This post walks you through connecting to a project and updating the DevOps items in Excel.
I had a need to use automation to do DevOps updates on behalf of another person so when the DevOps adoption metrics were done we the stats were slightly more accurate.
When a work item is assigned to you, you are sent a notification. In this post we show how Power Automate can update without notifications
Wiql is the language used to define the queries in Azure DevOps. Power Automate can use a REST API to execute the wiql.
DevOps REST API is a well documented API that we can easily use in Power Automate to perform a huge range of actions.
This post shows you how to find the names for fields and how to update fields in Azure DevOps using Power Automate
This post explores connecting Power Automate to DevOps for item creation and item editing and includes troubleshooting the connection
This post will finally create the flow to automatically create the Power BI workspace making use of all the preparation in previous posts.
