KNOWLEDGE BASE

Error "Unable to materialize temporary table" When Filtering View With a Measure


Published: 03 Nov 2016
Last Modified Date: 19 Jul 2017

Issue

When connecting to a MS SQL Sever data source through the generic ODBC Connector, and attempting to filter the view with a measure; the following error might occur:

"Unable to materialize temporary table"

Environment

  • Tableau Desktop
  • Other Database (ODBC) connector
  • MS SQL Server

Resolution

Use the native Microsoft SQL Server connector. For more information, see Microsoft SQL Server in Tableau Help. 

Cause

The generic ODBC connector is not designed to connect to MS SQL Server data sources, therefore Tableau cannot guarantee full functionality with all Tableau Desktop features, such as measure filters.
Did this article resolve the issue?