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
rad
New Member

Reporting test results from VSTS

Hi,

 

I'm trying how to report on test results stored in VSTS. Specifically I'm interested in a trend showing number of tests run per day (new test points in cube terms). I've connected to VSTS via the web UI and have the default dashboard, report and data set. I've tried creating a new report but I can't find any test related fields in the data source.

 

Would someone be able to point me to where I can find test results from VSTS? Is there a way to extend the data set?

 

3 REPLIES 3
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@rad,

Based on this official article, Test Results entity is not available in Power BI data model.

As a workaround, you can export the Test Results data from VSTS to Excel, then import Excel data to Power BI Desktop and analyze these data. For more details, please review this blog: http://www.toplinestrategies.com/blogs/bi/vsts-test-results-reporting-power-bi .

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lydia,

 

Thanks for the reply. It is worrying. Based on that official article the VSTS connector hasn't been improved in nearly 2 years.

 

The workaround won't help with the report we need. You can only get the latest result that way. Tests are rerun for various reasons and this hides the previous runs. Anyway, I've found a way get that data out to excel by copying test runs with total test MTM but it's a lot more manual work than it should be.

@rad,

About this issue, you can submit an idea in this link. You can also vote up this similar idea.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.