KNOWLEDGE BASE

Unable to Update the UNC Path for a Published Excel Data Connection


Published: 25 Apr 2014
Last Modified Date: 02 Jun 2016

Issue

When working with an Excel data connection published to Tableau Server, there is no option to update the UNC path for the data connection.

Environment

  • Tableau Server 
  • Microsoft Excel

Resolution

Use the following workaround:
  1. Download the workbook from Tableau Server.
  2. Open the workbook in Tableau Desktop.
  3. If a published data source is used, right-click the connection and select Create Local Copy.
  4. In the Data pane, right-click the data source, and select Edit Connection
  5. In the Excel Workbook Connection dialog box, type the full universal naming convention (UNC) path to the Excel data source in the Step 1 text box. For example, D:\datasource.xls has a UNC path that looks like the following: \\workstation1\d$\datasource.xls, where "workstation1" is the full computer name.
  6. Select Server > Publish Workbook.
  7. In the Publish Workbook to Tableau Server dialog box, clear Include External Files, and then click Publish.

Cause

The ability to update the UNC path for Excel data connections in Tableau Server is not currently available.
Did this article resolve the issue?