Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Unauthorized Access Error when publishing a large data set to Tableau Server

Moderator
Moderator
Created

Unauthorized Access Error when publishing a large data set to Tableau Server

 

When using publish to Tableau Server tool to publish a large .hyper or .tde file to Tableau Server, even though the credentials are all correct, the following errors still occur:

 

Tableau Server API Request (Upload file) Error Code 401002: Unauthorized Access -- Invalid authentication credentials were provided

Or

Tableau Server API Request (Publish file) Error Code 401002: Unauthorized Access -- Invalid authentication credentials were provided.

 

 

  • Confirm the credentials are correct
  • A small data set can be published Tableau Server with same credential with no error
  • The workflow executes more than 4 hours

 

Environment

 

  • Product - Alteryx Designer
  • PublishtoTableauServer tool

 

Cause

 

By default, the authentication token is good for 240 minutes (4 hours). After 4 hours, token is expired, and Tableau Server requires the new token for authentication. This is the reason you would see the unauthorized error when workflow executes for more than 4 hours of time. 

https://kb.tableau.com/articles/issue/Intermittent-HTTP-401-403-Errors-Using-the-Tableau-REST-API

 

 

Solution

  1. + Increase Tableau’s session timeout limit with tabadmin command:

    tabadmin stop

    tabadmin set wgserver.session.idle_limit <minutes>

    tabadmin configure

    tabadmin start

 

Additional Resources