TDS endpoint
Dataverse's SQL Server-compatible read-only endpoint — lets SQL-aware tools query Dataverse with T-SQL syntax.
The TDS endpoint is Dataverse's SQL Server-compatible read-only query endpoint. TDS (Tabular Data Stream) is the protocol SQL Server uses; tools that speak TDS — SQL Server Management Studio (SSMS), Power BI's SQL Server connector, ODBC / JDBC drivers, Tableau, Qlik — can connect to the TDS endpoint as if it were a SQL database. Connections authenticate via Microsoft Entra ID at port 5558. Supports full T-SQL syntax for SELECT queries — joins, aggregations, window functions, subqueries, CTEs. No writes — INSERT / UPDATE / DELETE not supported. Security (security roles, business units, field-level security) is honoured. For analytics at scale, Synapse Link for Dataverse is preferred; TDS suits SQL-aware ad-hoc analysis and moderate-volume Power BI direct queries.