Azure - Test Execution History with Test Case Name and All execution date and statu and Runby Query for Power BI

Question

Hi All,

My requirement - i am looking power bi Odata/ other query so that i can get below Test execution details in single query.

1. Test Case Name/ Title
2. Test Execution Status
3. All execution dates (if any tc is executed 5 times we need all 5 dates)
4. Status
5. RunBy / Executed by

Thanks,
Himanshu Jain

Answer 1

Hi @Himanshu Jain (himanshuj) ,

When you say Azure if you meant as Azure DevOps then Azure DevOps is currently not supported in this Microsoft Q&A platform. You may ask Azure DevOps related questions in this developer community. Also AFAIK, PowerBI related questions are currently not supported on this forum. It's better to reach out to dedicated forum over here.

Answer 2

Hi @tbgangav-MSFT - This is related Azure DevOps only. In 'https://learn.microsoft.com/en-us/azure/devops/report/powerbi/s', Micr7osoft provided couple of example for OData /power Bi and with this Sample queries i am able to get the data.

My requirement - i am not sure about Azure db query tables that's why i am requesting can you please provide me a query for above filer

Some examples provided by Microsoft Azure:
https://learn.microsoft.com/en-us/azure/devops/report/powerbi/sample-test-plans-progress-status?view=azure-devops&tabs=powerbi
https://learn.microsoft.com/en-us/azure/devops/report/powerbi/sample-test-plans-aggregate-data-level?view=azure-devops&tabs=powerbi

Thanks,
Himanshu

Answer 3

i am looking OData/powerbi query so that i can get below Test execution details in single query.

1. Test Case Name/ Title
2. Test Execution Status
3. All execution dates (if any tc is executed 5 times we need all 5 dates)
4. Status
5. RunBy / Executed by