Forum Discussion
Reporting test results from VSTS
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
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.