Need help in intergrating azure devops board with power bi

[jaga4brt]

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!!!

[kriscoupe · Accepted solution]

Hey @jaga4brt ,

One way you could solve this is with a bit of data prep in Power Query. You would need to bring in each Work Item Type hierarchy level as a separate query in Power Query (uncheck enable load on these) and then merge these back together from the lowest granularity (tasks and bugs) to the highest (epic) on Parent Work Item ID.

This should leave you with a single table with each row representing the flow from Epic down to the Tasks.

Hope it helps,

Kris

[denissatoru]

Hey, @kriscoupe . I'm new in Power BI.

Could you help me with step by step to do that?

Tks!