0

I am trying to create an Azure DO Analytic that I can bring into Power BI. Specifically I am trying to get all PBIs for the current sprint. When I pull up a PBI from the sprint the iteration path is:

xxxxxxxxxx\Enterprise PI Cadence\2025\Std 2 Week\254\25.4.1 SP(2wk)

But in the Field Criteria section of the Analytic creator in ADO there is an option for Iteration Path but the options are a drop down list and the choices are limited to two path items - like this:

xxxxxxxxxx\Enterprise PI Cadence\

When I verify the query it pulls way too many PBIs (4000+) when it should be ~40 for this sprint.

How can I filter the query to the specific sprint?

I tried creating an ADO Analytic but my options to get to a specific Iteration Path were limited.

Improve this question
Related questions
0
How can I pull all work items currently or previously associated with a Sprint in Azure DevOps
0
JIRA Azure DevOps iteration not showing work item in Azure DevOps
115
Azure devops users cant see repos even though they have full read/contribute permissions. How could we fix?
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.