This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on
10-04-2018
11:41 PM
- edited on
03-08-2019
12:11 PM
by
Community_Admin
ISSUE:
Error “ Error: Publish to Tableau Server (1): Tool #252: Tool #4: Tableau Server API Request (Publish file) Error Code 400011: Bad Request -- There was a problem publishing the file ‘ ’ “ when publish .hyper file of Excel with data source metainfo (.tds) file.
Repro Step:
Resolution:
Option 1
+ The original one looks something like: filename='H:/output.xlsx'
+ Change it to something similar to the following: filename='\\extendthereach.com\alteryx\CustomerSupport\output.xlsx'
Note: As a best practice, have the original Excel file in a share drive if it need to be used for other users in the organization or it will need to refresh on Tableau Server in the future. And make sure Tableau Server Run As User account has the sufficient permissions to access the share drive.
Option 2 -
If the Excel file has to be located on the end user’s machine, change the path in TDS file (line 8) to something like the following when the file in on local machine:
filename='\\?\C:\Users\kchen\Documents\Example named ranges.xlsx'
Note: If the Tableau Server Run As account does not have sufficient permission to access the share drive where the file is located, the following error would occur when connected to the Data source on Tableau Server:
“Unable to connect to the file "C:/Users/<Username>/Document/filename.xlsx". Check that the file exists and that you have sufficient access privileges for it. DataServiceFailure Unable to connect to the server "localhost". Check that the server is running and that you have access privileges to the requested database.”
See following Tableau KB for more information: