Tableau REST API 400 Error, Response Code 400011

Perhaps the best documented error in all of the Tableau REST API, Response Code 400011 is accurately described as the condition “Publishing Error”, with details “The workbook could not be published for some other reason than those specified earlier.” It’s a catch all for “you screwed up”, and there is absolutely no additional information you are going to get on what you did, even if you look at the API Server logs (trust me).

In building the rest_api_library, I’ve screwed up a whole lot, so I can at least provide a few instances where you will get 400 / 400011 for sure:

  • Publishing a TWB for a workbook that references external files (TDEs, XLSX, etc). Solutions:
    1. Re-save as a TWBX and publish the TWBX
    2. Publish your datasource to data server first, and connect the workbook to that datasource on data server
  • Publishing a TWB that references a data server source that doesn’t exist on that Site. Per the previous post on the topic, you can publish a TWB that connects to a data server source with the same name on a different site. But if you haven’t published the data source first, expect 400011 to be your fate
  • Publishing a TWB that references a data server source that published correctly, but didn’t embed credentials that are necessary. This may seem strange, but Tableau Server generates thumbnails for each worksheet at publish time, so if it can’t verify the server connection because it lacks credentials, then you’ll get a friendly 400011 response code as a reminder. Side Note: If you ever see your publish times take a long time, it is probably held up on generating the thumbnails, and it is a sign that your databoards are going to be miserably slow when people view them as well. Stop showing so much unfiltered data without doing some guided analytics first.

I’m sure there are more instances where 400011 can happen, but these are the major cases I’ve seen so far. I’ll keep updating as I come across them.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s