Unable to fetch Test Steps Data into PBI from Azure Devops Test Plan

[RenuBabu]

Hi Team,

I am trying to fetch the Test Steps data into PBI from Azure Devops Test Plans. I have used the below API to connect the data with Azure. I could fetch all the tables from azure like Test Points, Work Items etc. But I am not able to find the Test Step data in any table. Please find below screenshot for your reference.

Can you please assist me to understand how to fetch the Test Step data into PBI Desktop.

https://{Organization}/{Project}/_odata/v3.0-preview

Regards,

Babu

[v-zhengdxu-msft]

Hi @RenuBabu 

To fetch Test Step data, you'll need to use the appropriate API endpoint

Please try this endpoint:

POST https://dev.azure.com/{organization}/{project}/_apis/test/Runs/{runId}/results?api-version=5.0

These links may help you:

Azure DevOps API: get all testcase steps - Stack Overflow

OData API versioning - Azure DevOps | Microsoft Learn

Aggregated view for test suites sample Power BI report - Azure DevOps | Microsoft Learn

^{Best Regards,}

^{Zhengdong Xu}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[RenuBabu]

Hello Zhengdong Xu,

May I know which type of Authentication we need to give to connect the source?

And, also I am getting the below error while connecting to the Azure with the API that you have provided. Can you please assist on this.

Regards,

Babu