Last Modified Date: 03 Jan 2024
Environment
- Tableau Desktop
- Tableau Server
Answer
- 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 > [data source name] > 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.xls
has 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.
Additional Information
- 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 affects 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
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials