How to: Work Item Visualization report in Power BI using OData to connect Azure DevOps

In this example, based on a specific Work Item, I’ll show all work item links on Azure DevOps

An original report can be found on my GitHub repository. Let’s learn step by step how to create a report using OData.

To connect to Azure DevOps, using Power BI, we have the possibility of using OData. The Azure DevOps documentation is described step by step to this connection and we’ll use it for the example.

  • Based on the last post in this blog, where I teach how to connect OData, this time I’ll use WorkItemLinks table:
  • This table contains all relations between Work Items. Basically here, we have source and target columns that related Work Items (Features, Epics, User Stories, Tasks, Test Cases, Bugs, etc.) with link names (Parent/Child, Tests/Tested By, Related, etc.).
  • The report was based on Marketplace extension Work Item Visualization. Basically, we select one Work Item and show all links.
  • To use this report, select the respective Work Item on the list. It will be created a hierarchy structure to show all links:
  1. Work Item Title;
  2. Work Item Type;
  3. Link Type Name.

Please, let me know if you have any doubts about Azure DevOps and need to create reports on Power BI to extract metrics. Contact me on Twitter.

DevOps Consultant at N3