Error "Unable to materialize temporary table" Joining Data Sources

Published: 31 Aug 2016
Last Modified Date: 13 Jan 2017


When joining across multiple data sources, the following error might occur:

Unable to materialize temporary table


Tableau Desktop 10.0.0


Work with your IT team to add exceptions to your antivirus software and Windows Defender.
Note: Even if there is no antivirus software installed, Windows Defender may still be preventing the join from completing. 

Navigate to C:\Program Files\Tableau\Tableau <VERSION>\bin for 64-bit version. 
Navigate to C:\Program Files (x86)\Tableau\Tableau <VERSION>\bin for 32-bit version.

Add the following files to the exceptions list within the antivirus software and Windows Defender:
  • custactutil.exe
  • installanchorservice.exe
  • uninstallanchorservice.exe
  • tableau.exe
  • tabprotosrv.exe
  • TabOnlineSyncClient.exe
  • TabOnlineSyncClientCmd.exe
  • TabOnlineSyncSvc.exe
  • tdeserver64.exe



Antivirus is preventing Tableau Desktop from working as expected. 
Did this article resolve the issue?