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.
Oh no! The Community appears to be haunted! Help us find all the spooky specters here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email email@example.com for assistance.
The partnership between Alteryx and Tableau is becoming stronger and stronger, and the seamless effortless integration has been made easier through the Publish to Tableau Server Tool. This article demonstrates the use of the Publish to Tableau Server tool, available on the Alteryx Analytics Gallery.
Every so often we get questions about a .tde (Tableau Data Extract) file that is being output from Alteryx that has a file size of 30k when the original data is much larger. When the file is opened in Tableau this error sometimes comes up: An error occurred while communicating with data Source ‘yourfilename.tde’
If you observe an error message like Error: Salesforce Input (1) File " ", line 1 os.environ['PATH'] = r"... please read on to learn how to adjust the environment variables to resolve it. This can happen with any one of several Connector tools, not just the tool mentioned in the example.
User receives error when outputting hyper file:
Failed to start a new Hyper instance. Context: 0x86a93465 Caused by: The Hyper server process exited during startup with exit code: 1, Command-line: ""C:\Program Files\Alteryx\bin\Tableau\bin\hyper\hyperdstarter.exe" -x "database_directory=C:\Users\SVRC0049\AppData\Local\Temp"
When attempting to publish a workflow to your private Gallery which contains the Publish to Tableau Server macro, you may encounter an error similar to this: “Cannot find macro "PublishToTableauServer_v1.08.1\Publish to Tableau Server.yxmc"
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.
Connect to an Excel file on Tableau Desktop
Create an Extract with .hyper extension
Then right click on the data source > add to Saved Data source, to create the metadata file (.tds) file
Open Alteryx Designer, connect to the same Excel file using input tool
Drag a publish to Tableau Server tool, type in all the relevant information, for Data source metainfo (optional), select the .tds file created in step 3
When run the workflow, this error would occur
Do not create extract of the file, for text based file, do no need to create a local copy
After created the .tds file (add to Saved Data source) , open the .tds file in a text editor like notepad ++
Modify on line 8, where filename = ‘ ’, change the path to UNC path
+ 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 😎 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.
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: