KNOWLEDGE BASE

Error "Tableau Data Engine Error: 406: Unable to connect to the file" Connecting to Excel


Published: 29 Sep 2016
Last Modified Date: 19 Oct 2016

Issue

When connecting to an Excel data source, the following error occurs:
Tableau Data Engine Error: 406:Unable to connect to the file. Check that the file exists and that you have sufficient access privileges for it.

Environment

  • Tableau Desktop 10.0.0
  • Windows 10
  • Excel

Resolution

  • Open Tableau Desktop as Administrator (right click on Tableau icon and select "Run as administrator") and attempt to connect again to the Excel file. 
  • Work with your IT team to ensure that your user account has administrator rights or security permissions to the AppData folder.  
  • Work with your IT team to whitelist the temporary files folder in your anti-virus or firewall. 

Cause

Either the user account does not have the necessary permissions to access the file, or antivirus is interfering with the connection. 
Did this article resolve the issue?