Error: "Unable to materialize temporary table" Joining Data Sources

Issue

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

Unable to materialize temporary table

Environment

Tableau Desktop

Resolution

Work with your IT team to add the below files, located in the Tableau bin folder, as 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.

custactutil.exe
installanchorservice.exe
uninstallanchorservice.exe
tableau.exe
tabprotosrv.exe
TabOnlineSyncClient.exe
TabOnlineSyncClientCmd.exe
TabOnlineSyncSvc.exe
tdeserver64.exe

By default, the Tableau bin folder is located by default at C:\Program Files\Tableau\Tableau <VERSION>\bin for 64-bit versions of Tableau Desktop or C:\Program Files (x86)\Tableau\Tableau <VERSION>\bin for 32-bit versions of Tableau. Desktop.

Cause

An antivirus is preventing Tableau Desktop from working as expected.

Additional Information

See Add an exclusion to Windows Defender for additional information about this topic.

Discuss this article... Feedback Forum

Click here to return to our Support page.

Open a new case

Click here to go to our Support page.

Get detailed answers and how-to step-by-step instructions for your issues and technical questions.

Find and share solutions with our active community through forums, user groups and ideas.

Browse a complete list of product manuals and guides. Available online, offline and PDF formats.

Learn how to master Tableau’s products with our on-demand, live or class room training.