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

[AchTiw]

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. 

[AchTiw]

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 ?

[v-eqin-msft]

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]

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.