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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AchTiw
Frequent Visitor

Azure DevOps- Test Plan based report- Help with Power Query/Odata Query

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. 

3 REPLIES 3
AchTiw
Frequent Visitor

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: 

https://docs.microsoft.com/en-us/rest/api/azure/devops/test/test%20%20plans/list?view=azure-devops-r...

https://docs.microsoft.com/en-us/rest/api/azure/devops/test/test%20%20plans/get?view=azure-devops-re...

 

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.

 

v-eqin-msft
Community Support
Community Support

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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