KNOWLEDGE BASE

Tableau Server Fails to Refresh Extract Using Network Shared Drive Flat File Data Source Like Excel

Published: 11 Mar 2024
Last Modified Date: 13 Mar 2024

Issue

When refreshing a workbook data source coming from a shared drive flat file like Excel on Tableau Server, the following example error would occur: 

Unable to connect to the file "C:/ProgramData/Tableau/Tableau Server/data/tabsvc/temp/backgrounder_1.20233.23.1227.1336/TableauTemp/FAKEPATH-17gjk000jspzws1ev1a8w1g0d4l2". Check that the file exists and that you have sufficient access privileges for it.

Environment

  • Tableau Server
  • Excel
  • Text file

Resolution

Tableau Desktop Publishing

1. When Tableau Desktop connects to the source, the file path should be the exact UNC path.

User-added imageUser-added image

2. When publishing to Tableau Server, uncheck the box Include external files.

User-added image

Tableau Server Updates

On the Tableau Server machine, add the UNC path in the allowlist as per this article: Configure a server allowlist for file-based data sources.  See Part 11:Configure a server allowlist for file-based data sources. The example details are as follows:
  1. tsm configuration set -k native_api.allowed_paths -v "\\dvfilesrvxxxx\bxxxxx\cxxxx\_Gxxxx\0xxxxx\094xxxxx"
  2. tsm pending-changes apply
If using a Prep flow, then review the article: Step 4: Safe list Input and Output locations.  The example details are as follows:
  • For input connections:

tsm configuration set -k maestro.input.allowed_paths -v your_networkdirectory_path_1;your_networkdirectory_path_2

tsm pending-changes apply

  • For output connections:
tsm configuration set -k maestro.output.allowed_paths -v your_networkdirectory_path_1;your_networkdirectory_path_2

tsm pending-changes apply

Cause

Incorrect options were selected when publishing a workbook or data source.
Did this article resolve the issue?    
PRINT THIS PAGE
Trending Articles
Attachments


All Support

SUPPORT BY PRODUCT
TOOLS & DOWNLOADS
INFORMATION
ASSISTANCE