Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
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.
Regards,
Babu
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
211 | |
86 | |
64 | |
59 | |
56 |