Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to fetch test plan data from Azure devops & followed direction in below link. But all these sample reports gives bits & pieces of data (Only tester name). Any guidance on how can I retrieve complete Test plan data for 1 project?
I amlooking for Test Suite, Test case id, outcome, Tester for all the test plan under one project. I do not want to specifiy test plan name explicitely, because there can be many over period of time.
Manual test Tester by Outcome matrix sample Power BI report - Azure DevOps | Microsoft Docs
let Source = OData.Feed ("https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/TestPoints?" &"$apply=filter((TestSuite/TestPlanTitle eq '{testPlanTitle}'))" &"/groupby((Tester/UserName, LastResultOutcome)," &"aggregate($count as Count)" &")", null, [Implementation="2.0"]) in Source
I tried inserting $select for testcaseid column, but recieving bad request error.
Hi Eyelyn, Thank you for response.
I have gone through all above link & got only few datapoints. I am trying to modify given queries, but constantly getting error.
How do I fetch some more columns like Test case id, test plan name ?
Hi @AchTiw ,
It seems that you want to get some details about test plans, please try this sample:
GET https://dev.azure.com/fabrikam/fabrikam-fiber-tfvc/_apis/test/plans?includePlanDetails=true&api-version=5.0
Or get test plan by ID:
GET https://dev.azure.com/{organization}/{project}/_apis/test/plans/{planId}?api-version=5.0
Please take a look at the official documents:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AchTiw ,
Please refer to:
Use OData queries to generate Power BI reports - Azure DevOps | Microsoft Docs
Create test plans and suites - Azure Test Plans | Microsoft Docs
Connect with data by using OData queries - Azure DevOps | Microsoft Docs
Connect using Power Query & Azure DevOps functions - Azure DevOps | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |