Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
DavidPlante
Regular Visitor

How to get State from test case from Azure DevOps

Hi!

I'm looking for a solution to this: I need to query all test cases under a particular Test Plan, and fetch the State value, so I could calculate a percentage of test case "Ready" on the total of test case under that suite.

 

I was planning to start from entitySet Tests or TestPoints, but neither of those have the State. 

 

Then, I thought I could use the entitySet WorkItem, but I can't find a way to track Test Cases from a given Test Plan.

 

Any thought on how I could achieve this? The end goal here is to calculate a percentage of "Ready" tests from all the test cases under a particular Test Plan.

 

Thanks and have a nice day!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @DavidPlante ,

Perhaps you can try to use odata connector to get data from azure devops with custom queries:

How can I connect PowerBi to Queries in Azure Devops? - Stack Overflow

Regards,

Xiaoxin Sheng

View solution in original post

1 REPLY 1
Anonymous
Not applicable

HI @DavidPlante ,

Perhaps you can try to use odata connector to get data from azure devops with custom queries:

How can I connect PowerBi to Queries in Azure Devops? - Stack Overflow

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.