Need help in intergrating azure devops board with power bi

jaga4brt — Sat, 30 Mar 2024 09:10:30 GMT

Hello, everyone. we're in the process of integrating Azure DevOps Board withPower BI. Our client requires Azure Boards data to be visualized in Power BI. Here's an overview of my data

structure:

In Table A, we have columns such as Work ItemType, Work Item ID, Parent Work Item ID, and Assigned To.

The Work Item Type column contains values likeEpic, Feature Set, Feature, User Story, Tasks, andBugs.

For each work item type, a corresponding Work ID is generated. Typically, the flow follows this sequence:Epic → Feature Set → Feature → User Story → Tasks and Bugs assigned to the User Story.

Epic usually does not have a parent Work Item ID, but the other work items have relevant Parent Work Item IDs that depend on the hierarchy flow.

How can I effectively create a table and establish a hierarchy in this scenario?

I need to drill down hierarchally.

Someone help!!!

jaga4brt Tracker

Need help in intergrating azure devops board with power bi