KNOWLEDGE BASE

Error "no such table [TEMP].[#Tableau_1_Filter]" Incrementally Refreshing Extract


Published: 22 Nov 2013
Last Modified Date: 26 May 2016

Issue

When you try to incrementally refresh an extract published to Tableau Server, the following error might occur:

Tableau Data Engine Error: 4: no such table [TEMP].[#Tableau_1_Filter]
TableauException: Invalid set function Unable to create extract

Environment

  • Tableau Server 
  • Extract
  • Data source filter
  • Incremental refresh

Resolution

Remove any extract filters added by Tableau Desktop when the data source filter was originally applied to the extract:
  1. In Tableau Desktop, open the extract or the workbook that contains the extract.
  2. Right-click the extract in the Data pane, and then select Extract Data.
  3. Remove any filters listed in the Filters (optional) section of the Extract dialog box, and then click Extract.
  4. Publish the revised extract or workbook to Tableau Server.

Cause

When data source filters are added to extracts in Tableau Desktop, the filter is automatically added to the Extract filters. This improves performance in Tableau Desktop, but the extract level filters must be removed before publishing to Tableau Server to avoid filters that Tableau Server cannot evaluate.
Did this article resolve the issue?