Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Tableau Publish to Server Error signing in to Tableau Server

hroderick-thr
11 - Bolide

This is a strange situation but definitely a big problem for me.

My personal credentials work just fine with the Tableau Publish to Server tool.

I need to use the service account credentials which we use with tabcmd to publish Tableau datasources. This is the same service account running the Tableau Server. It is a Tableau Server Admin with full permissions.

 

I can use the service account credentials to set up the tool connection, then see the list of projects and datasources and such in step 2 of the tool's configuration.

But when I run the configured tool, this happens: ☹️

Publish to Tableau Server (123) Tool #33: Tool #4: Tableau Server API Request (Sign-in) Error Code 401001: Signin Error -- Error signing in to Tableau Server

 

I have a hunch the problem is special characters in the service account name (.) or the password (+=@). What do you think?

 

3 REPLIES 3
hroderick-thr
11 - Bolide

I should have searched better because this has been solved here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Publish-to-Tableau-Server-Error-Messag...

 

Adding a bit to it, these characters seem to cause trouble:

 

These need special handling for command line apps

https://community.tableau.com/s/question/0D54T00000C6ntnSAB/special-characters-in-usernamepassword-i... 

 

Capture.PNG

 

 

 

These cause problems in urls

https://kb.tableau.com/articles/issue/special-characters-in-url-parameters

hroderick-thr_0-1602338162474.png

 

So avoid these

! * ' ( ) ; : @ & = + $ , / ? # [ ] | < > \ ^ ” * % 

 

I've found $ is OK if you must have one. There are ways of dealing with special characters in userids and passwords, but it would take a fix to the tool at the code level to add escape syntax to them

 

 

 

 

mkosmicki1
8 - Asteroid

I use TabCmd to do some of my server processing and always forget that may Tableau Password cannot have those specific special characters. thanks for posting this here because there are probably more than one of us that need the reminder and the solution. 🙂

 

Best,

 

Michelle

bdewitt760
5 - Atom

I removed the special characters and it worked.  Thanks so much for posting this as i was having the same problem. 

Labels