Forum Discussion

Changlin's avatar
Changlin
Frequent Visitor
4 years ago

How to get test cases info data from a specific test suite in Azure DevOps Test Plan?

Hi everyone,   I'm working on creating a dashboard which needs test cases data from Azure Devops. I have found a doc to get test progress data - Manual test progress status sample Power BI report -...
Need Help
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
4 years ago

Hi Changlin ,

Based on the sample query, looks like it connects to Analytics view by OData connector.

 

To connect to Azure Devops Server Anyalytics view, you can try to use to built-in connector directly, refer this documents which introduces it in details:

Connect to Analytics with Power BI Data Connector 

 

About the query parameter for Analytics, it looks like this in Power Query:

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Changlin's avatar
Changlin
Frequent Visitor
4 years ago

Hi v-yingjl ,

 

Thanks for your answering. I have tried using Analytics view function directly in Azure Devops, it can let me filter test cases but seems cannot access the execution reslult infomation of test cases.

 

What I need is get each test cases name and their execution duration info, so I am trying to use odata query to get those data from Azure DevOps Server. But all official documents I can find are only talk about how to get execution outcome status of test cases, like "pass", "failed" and so on.

 

Is there anyway allow user to get test cases execution duration info and pull data into Power BI?

 

Best regards,

 

Changlin