question

How do we show the execution test trend ? when we have multiple test rounds in a test plan...?
Wanted to use Power BI Desktop to show the test execution trend instead of using manually excel to track the following number of test cases being execution progress.. Pass, Fail, Not executed, Not applicable....e.t.c

Test Suite
|
+-> Test Round 1
| |
| + STS Feature 1 (contains no. of test cases)
| + STS Feature 2 (contains no. of test cases)
|
+-> Test Round 2
|
+ STS Feature 1 (contains no. of test cases)
+ STS Feature 2 (contains no. of test cases)

Found the resources link here, but I am not very familiar on how the query editor works, what the filter to be used - also due to my structure of the test suites making the query more complicated

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/sample-test-plans-execution-trend?view=azure-devops&tabs=powerbi:
https://docs.microsoft.com/en-us/azure/devops/report/powerbi/sample-test-plans-aggregate-data-level?view=azure-devops&tabs=powerbi

Anyways, where we can grab the query results based from the test suites test plan ID?

Thank you.