Forum Discussion

jorgemendoza's avatar
jorgemendoza
Copper Contributor
Aug 23, 2023

How to connect Tableau to Azure DevOps test result tables?

Hi All,

 

I need to connect to test results (datababase/tables) Azure DevOps 2022, I found this:

 

https://analytics.dev.azure.com/<account>/<Project>/_odata/v2.0/

 

But I can connect only to project tables, not the ones having the result of test cases executed.

 

Also I found that maybe CDATA drivers can help but spending money is not an option.

 

Do you know if there is a way to connect to test tables? maybe to connect to tfs_warehouse database or any other database?

 

I can see only theses tables:

  • Areas
  • BoardLocations
  • Dates
  • Iterations
  • Processes
  • Projects
  • Tags
  • Teams
  • Users
  • WorkItemBoardSnapshot
  • WorkItemLinks
  • WorkItemTevisions
  • WorkItems
  • WorkItemSnapshot
  • WorkItemTypeFields


Thanks
Jorge

azure devops

1 Reply

Sort By
  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Aug 31, 2025

    Consider this as workarounds:

     

    1. Query Azure DevOps REST API

    You can use the Azure DevOps REST API to pull test results programmatically:

    • Use endpoints like /test/runs, /test/results, /test/points
    • Authenticate using a Personal Access Token (PAT)
    • Export the data to a format Tableau can read (CSV, Excel, etc.)

    You can then automate by PowerShell or Python and refresh the data periodically.

    1. Direct SQL Access (On-Premises Only)

    If you're using Azure DevOps Server 2022 (on-premises), you may have access to the TFS_Warehouse or collection databases:

    • Connect Tableau directly to the SQL Server instance
    • Look for tables like tbl_TestResult, tbl_TestRun, tbl_TestPoint
    • Be cautious: Microsoft doesn’t officially support direct querying of these databases, and schema changes may occur across versions
    1. Power BI as a Bridge

    Power BI has better support for Azure DevOps via REST API and can be used to:

    • Pull test data
    • Model and clean it
    • Export to Tableau-compatible formats

    This adds a step, but avoids paid connectors like CDATA.

Resources