Forum Discussion
Unable to fetch Test Steps Data into PBI from Azure Devops Test Plan
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
2 Replies
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.0These 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.
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
