Hello Community,
Per title, I'm consistently hitting an error with trying to publish a .csv as a .hyper file to the Tableau Server for my company:
"Error - ToolId 9: Tool #252: Tool #4: Tableau Server API Request (Publish file) Error Code 400011: Bad Request -- There was a problem publishing the file '12598:d4678842b0a74bbaa42f488377d8fd74-1:0'."
I've followed other guides online and performed the following steps:
1. Saved the metainfo (in a .tds file) to a folder, and brought a .csv file into alteryx, attaching it to the 'publish to tableau server' tool. I have saved the .csv and .tds file in the same folder ("TDSFILES") on my desktop, and both are named "SampleSuperstore"
2. Used notepad++ to edit line 8 of the file to read as a path to where I have saved the initial csv file ("C:\Users\EmployeeNumber\Desktop\TDSFILES\SampleSuperstore.csv")
3. Used notepad++ to edit the tableau server version in the .tds file to show the correct version
4. Configured the 'publish to tableau server' tool to the correct logins and the Data Source Metainfo is a path to the .tds file in the same folder as above on my desktop.
Running this yields the same error consistently - I'm unable to find any further help online. My thought is maybe I incorrectly edited something in the .tds file using notepad++.
-Where should line 8 of the .tds file direct to?
-Does the original file NEED to be a .csv, .xlsx, or .hyper, or are any fine?
Thank you in advance for your help
Solved! Go to Solution.
Hi Reston,
Please review this KB article from Tableau on publishing metadata: Tableau KB. It mentions the .tde files included metadata, while the newer .hyper files do not, and that .tdsx or .twbx files are used for metadata starting with version 10.5.
Thanks,
Eric West
Customer Support Engineer
Alteryx, Inc.
Thanks Ben,
I actually had a call with Alteryx support and the solution we covered is the same as your colleagues blog post, so that helps a lot for future reference.
Do you know if this still works when publishing to Tableau Server 2019.2? I noticed the .tds had different text than the example did after our company's server update.
@zm1 the publish with tds option has been uncooperative with 2019.4 and 2020.1. I have an open Alteryx ticket - they replied that they're aware of the issue and would follow-up when resolved.