Last Modified Date: 28 Dec 2017
- Tableau Desktop
- Tableau Server
- In Tableau Desktop, right click on the data source in the Data Pane and select Edit Data Source.
- From the Data Source window, select Data > Edit Connection from the top menu.
- In the Excel Workbook Connection dialog box, type the full universal naming convention (UNC) path to the Excel data source.
- For example,
D:\datasource.xlshas a UNC path that looks like the following:
\\workstation1\d$\datasource.xls, where "workstation1" is the full computer name.
- Select Server > Publish Workbook.
- In the Publish Workbook to Tableau Server dialog box, uncheck Include External Files.
- Click the Publish button.
- Make sure that the Tableau Server Run As User account has access to the location where the Excel file is saved.
- Unchecking Include External Files ensures that Tableau Server connects directly to the original Excel file.
Note: Include External Files effects all external files used in the workbook.
- After adjusting the path and publishing the workbook to Tableau Server, you can test the permissions on Tableau Server by selecting the Data Source then selecting Action > Create New Workbook.
- Successfully being able to create a workbook indicates that Tableau Server has access to that file.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials