This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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!
Solved! Go to Solution.
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
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
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.