How to Pull Azure DevOps Data into Power BI – Without Losing the Hierarchy

Recently, I had to build a cross-team report in Power BI based on Azure DevOps backlog data.

The goal: track completion rates from Epic → Feature → User Story, and keep the full hierarchy intact.

At first, I thought:

“I’ll just connect via Analytics View – done in five minutes, right?”

Not quite.

Once I loaded the data, the Parent column was full of blanks, the hierarchy broke, and some key fields were missing entirely.

That’s when it hit me: while Analytics View is quick, it has hidden field and row limits. For full hierarchy analysis, it just doesn’t cut it.

So, I switched to WIQL + Azure DevOps REST API – and finally got complete, flexible data.

What I Tried

Option 1 – Analytics View

• 👍 Super quick to set up
• 👎 Missing Parent values, limited fields

Option 2 – Shared Query + API (final choice)

• 👍 Complete data, custom fields possible
• 👎 Requires a bit of M code (template below)

You’ll Need Four Key Inputs

1. ORG → Your Azure DevOps organization name (https://dev.azure.com/{ORG}/)