https://community.fabric.microsoft.com/t5/Developer/How-to-get-State-from-test-case-from-Azure-DevOps/m-p/3988665#M53350 <P>Hi!</P><P>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.</P><P>&nbsp;</P><P>I was planning to start from entitySet Tests or TestPoints, but neither of those have the State.&nbsp;</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Thanks and have a nice day!</P> Wed, 12 Jun 2024 12:59:00 GMT DavidPlante 2024-06-12T12:59:00Z https://community.fabric.microsoft.com/t5/Developer/How-to-get-State-from-test-case-from-Azure-DevOps/m-p/3988665#M53350 <P>Hi!</P><P>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.</P><P>&nbsp;</P><P>I was planning to start from entitySet Tests or TestPoints, but neither of those have the State.&nbsp;</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Thanks and have a nice day!</P> Wed, 12 Jun 2024 12:59:00 GMT https://community.fabric.microsoft.com/t5/Developer/How-to-get-State-from-test-case-from-Azure-DevOps/m-p/3988665#M53350 DavidPlante 2024-06-12T12:59:00Z https://community.fabric.microsoft.com/t5/Developer/How-to-get-State-from-test-case-from-Azure-DevOps/m-p/3989986#M53376 <P>HI&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/460363">@DavidPlante</a>&nbsp;,</P> <P>Perhaps you can try to use odata connector to get data from azure devops with custom queries:</P> <P><A href="https://stackoverflow.com/questions/65201453/how-can-i-connect-powerbi-to-queries-in-azure-devops" target="_blank">How can I connect PowerBi to Queries in Azure Devops? - Stack Overflow</A></P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Thu, 13 Jun 2024 02:26:57 GMT https://community.fabric.microsoft.com/t5/Developer/How-to-get-State-from-test-case-from-Azure-DevOps/m-p/3989986#M53376 Anonymous 2024-06-13T02:26:57Z