Forum Discussion

panoslondon645's avatar
panoslondon645
Copper Contributor
Dec 15, 2023

export data from devops

Hi,

 

I would like to exprort some data from Azure devops. More specifcially from below data. Is it possible to extract data say as csv or by PowerBi or into Excel? I also saw some posts with some SQL like queries from devops but where do i get this option? Thank you.

 

 

    • panoslondon645's avatar
      panoslondon645
      Copper Contributor
      Hi, thanks but that;s not part of a query , it's a test case and the results of the runs. Do you think it will be possible to do the same output via a query? plus can i scheduloe it? Thank you.
  • panoslondon645's avatar
    panoslondon645
    Copper Contributor

    So i have something like this  but the main item thatr's is missing is the "Outcome" Passed or Failed. So it seems that i am not using the right query type  or just can't get the test result runs outputs from a "Query" window . Any ideas? Maybe someone knows what fields to select exactly in a query? Thank you. 

     

     

Resources