PAT Publish to Tableau Server

[#1]

PAT Publish to Tableau Server
v1.1.0

Adapted from the Publish to Tableau Server tool Developed by Alteryx.
Publish data to an instance of Tableau Server or Tableau Online.

This tool is compatible with:

• Alteryx 2018.2+
• Tableau Server 10.5+

Current known issues:

• PAT tokens can only be used by a single application at a time, this means if two output tools run at the same time, the second will fail. For now it is recommended to use a single PAT per output tool.
• Save connection functionality is currently bugged.

[Rasmuslarsen]

Hi @MinaGO3 

Thanks for a great tool that works! This has really been causing a headache for me and this tool solved it. 

Do you know if the issue regarding two output tools will be fixed at some point? 

Best regards,

Rasmus

[Aparker8709]

Thank you for creating this!! It works great and is the only option that has worked for me. Minor inconvenience having to create a separate PAT for each dataset, but I'm happy to be in compliance with the MFA requirement for Tableau. 

[nathayoung]

Thank you for this.  This got me past the datetime issue with the 'new' Tableau Output tool.  I will be directing my team towards this for sure.   

[Danny-Farrar]

This has saved our team a real headache with the MFA switchover (using the Tableau Output tool for larger files was simply not working) - thank you!!

[lrhodig]

This tool doesn't work for me. I go to our Tableau Server, create a PAT in my user settings, then copy that information over to the tool in Alteryx. The tool is able to connect just fine - I am able to access the configuration page with options for Project Name, Data Source Name, etc. Unfortunately, this is as far as I get. Every time I run the workflow, I get the error "Tableau Server API Request (Sign-in) Error Code 401001: Signin Error -- The personal access token you provided is invalid."

[Bonfire98A]

I am receiving the same error as Irhodig, in that the token works at the configuration screen, but not at actual runtime.  What is even more odd is that we have one token for which the workflow will run perfectly, but two others for which we receive the invalid token error (we have three identical workflows that publish to separate Tableau data sources; the test one works but the two production ones do not).  Our Tableau admin is not aware of any differences among the three tokens, so I am wondering if something in the tool could be causing this behavior.  

I am also in contact with Alteryx Support to see if we can get their Tableau Output tool to work, but we receive spatial data compatibility errors when we attempt to use it (the data we are publishing has a spatial component).  This is in spite of the fact that I am using the latest version of that tool (1.2.0) which supposedly supports spatial data.

[Aparker8709]

Sometimes I have to create the PAT more than once for it to take. Some days new PATs work on the first try and some days I have to repeat the process over and over to get it to work. On rare occasions I just try again the following day. Eventually they do take for me. And just as a reminder, make sure you are using a separate PAT for each datasource since a PAT can only be used for one datasource at a time. 

[Bonfire98A]

Thanks, Aparker8709 - very good to know, but very discouraging that PATs are turning out to be so fickle.  I will create new tokens until I get one that finally "sticks," so to speak.

[Aparker8709]

Yeah, not ideal but it's the only thing I've found to work. Something else to be aware of in case you didn't know... make sure to run the workflows at least once every 2 weeks if you want to keep your PATs active. Even then, they eventually time out. Keeping them active as long as possible is easier than trying to replace them all the time when they sometimes work and sometimes don't. 

Info from the Tableau website: 

Token expiry

Personal access tokens will expire if they are not used after 15 consecutive days. If they are used more frequently than every 15 days, an access token will expire after 1 year. After a year, you must create a new token. Expired personal access tokens will not display on the My Account Settings page.

[ErlinaIrvine]

My coworkers are not able to install this tool and get this error. Do you know why they might see this error when installing the tool?

[FrankDroogh]

I noticed that all Tableau generated tokens with a '+' (plus-sign) in it are causing errors.

If people are still experiencing the error "Tableau Server API Request (Sign-in) Error Code 401001: Signin Error -- The personal access token you provided is invalid."

I just had to replace quite some tokens because they expired. After getting new tokens in Tableau, implementing them in Alteryx and running the flows, I noticed the random invalid-errors and saw that out of 30 new tokens, 9 had a + in, and only those 9 failed.

So if you generate a new token containing a + , save yourself the trouble and right away generate a new one!