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

  • 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.




Tech Solution Architect Manager na Accenture

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

On EQT Ventures’ Investment in CodeSandbox, tackling the final frontier in collaboration

Nested Datasets Hierarchy Pattern in MySQL

New Ansible Playbook with Roles & Vault to create an instance in AWS from Anywhere!

What I learned from participating in Hash Code 2022

Continuous Integration

Spring boot logging proper SQL statements/logs while using Hibernate JPA.

Firebase Android Codelab

Echo VR Dev Log | March 30, 2020

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Vinicius Moura

Vinicius Moura

Tech Solution Architect Manager na Accenture

More from Medium

How to: Team Projects, Fields, and Picklists Mapping on Azure DevOps

How to set up the Azure Front door for your web application?

How to extend an Azure DevOps YAML Pipeline Template

Loading KeyVault secrets and AppSettings in to application configuration in Azure Function Apps