How to connect Tableau to Azure DevOps test result tables?

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.

2. 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

3. 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.