In this video, I answer a question from the community about extracting tagged usernames from comments in Azure DevOps and displaying who has the next action item using Power BI. I walk you through the process step-by-step, from retrieving the latest comments in Azure DevOps, to using Power Query functions to isolate and display the tagged usernames. By the end, you’ll know how to identify action owners based on tagged comments in your work items. Don't forget to like, subscribe, and share what you've learned!

Key Links:
GitHub Link to retrieving comments - [ Ссылка ]

Chapters & Timestamps:
00:00:00 - Introduction: Video overview and addressing the question.
00:00:21 - Understanding the Requirement: Explanation of the scenario—tagging stakeholders in comments.
00:00:59 - Setting Up Azure DevOps: Demonstrating how to tag users in Azure DevOps.
00:01:31 - Power BI Setup: Opening Power Query to start the process.
00:02:22 - Extracting Comments with Power Query: Retrieving the latest comment from Azure DevOps.
00:03:18 - Transforming Data in Power Query: Steps to extract text from tagged comments.
00:04:19 - Filtering Comments with Tags: Filtering comments to find tagged users.
00:05:18 - Isolating Usernames: Writing a custom formula to extract usernames from tagged comments.
00:06:34 - Limitations and Solutions: Discussing challenges with partial names and how to handle them.
00:07:24 - Recap & Conclusion: Review of the process and final thoughts.

свернуть