KNOWLEDGE BASE

Resolving Error When Publishing Workbook with a File-Based Data Source


Product(s): Tableau Desktop
Version(s): All
Last Modified Date: 16 Aug 2016

Article Note: This article is no longer actively maintained by Tableau. We continue to make it available because the information is still valuable, but some steps may vary due to product changes.


When publishing a workbook whose data source is a Microsoft Access, Microsoft Excel, or text (.csv) file that is located on a shared drive, you may see an error message similar to this one:

 

Error communicating with the repository (999): Vizql::Error: Unable to load workbook SampleWorkbook

Code: 999

Details:

Errors occurred while trying to load the workbook "SampleWorkbook". The load was not able to complete successfully. Microsoft JET database error 0x80004005: 'S:\Reporting\CompanyData\Q1-2011.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

The table "TableauData" does not exist.

Unable to connect to the Microsoft Access database "C:\Program Files\Tableau\Tableau Server\data\tabsvc\temp\DB12.tmp\Data\zzAutomated_Reporting\DO_NOT_OPEN.mdb". Check that the path is correct and that you have access privileges for the requested file.

 

This message displays because the path to connect to the data source is using a mapped path. Tableau Server uses the “Run As User” account to authenticate a data source. Because the “Run As User” account cannot access resources that have been authenticated in the security context of another user, it cannot use the mapped path.

To resolve this issue, edit the data connection in the workbook to use the full universal naming convention (UNC) path, and then republish the workbook. A UNC path is the full path of a resource or file that is stored on the computer, which includes the full computer name, drive, path to the file, and file name. For example, a text file with a mapped path to D:\datasource.txt has a UNC path that looks like the following: \\workstation1\d$\datasource.txt, where “workstation1” is the full computer name.

Note: A correctly configured Tableau Server “Run As User” account has permissions to the UNC path location.

 

Alternate Search Terms:999, communication error, repository error
Did this article resolve the issue?