Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
RenuBabu
Frequent Visitor

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

 

RenuBabu_0-1707140362935.png

 

 

 

Regards,

Babu

2 REPLIES 2
v-zhengdxu-msft
Community Support
Community Support

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.

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.

RenuBabu_0-1707221789007.png

 

 

Regards,

Babu

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.