I am wondering if anyone knows how to publish or update an existing a Tableau Workbook to Tableau Server? I can write a .tde directly to server, but cannot find a solution to publish/update a workbook. Any recommendations and/or help would be greatly appreciated! Thanks!
Solved! Go to Solution.
http://help.alteryx.com/10.5/index.htm#Macro-TableauServerPublish.htm?Highlight=Tableau
there is a tool available for download from the gallery that was made for you.
MarqueeCrew-
I actually been using this macro, but from my understanding it only publishes .tde file. Am I missing something?
The goal is to publish a workbook or an existing workbook to the server. Do you know if that's possible?
If you have a workbook connected to the .tde file it should refresh when you publish.
Have you tried this?
Hi Fain-M,
I am thinking there is some miscommunication it almost sounds like you are trying to publish a .twb or a .twbx, so a workbook or packaged workbook. If this is what you are looking for you can publish these but you need to use tabcmd. Tabcmd can be run in Alteryx using the "Run Command" tool, but you will need to install tabcmd on your computer which you either need to get from your server or go to a third party site to get (I think The Information Lab has it on there site). The documentation for tabcmd can be found here: http://onlinehelp.tableau.com/current/server/en-us/tabcmd_cmd.htm .Tde files are only the data source for the Tableau workbook. If you are trying to update these you can use the "overwrite" option within the Publish to Tableau server tool and that will update the data source.
AndrewKim,
Thank you for your reponse. I appreciate the help. I actually figured out this issue, it was a lot easier than anticipated. I published the .tde file to Tableau Server and then opened my tableau dashboard which was sitting on my desktop and not the server. In Tableau I connected to a new data source, which was the .tde file that I published from Alteryx. Lastly, I replaced the existing data source with the .tde file from server and then published the dashboard to Tableau Server. Now everytime I run the workflow within Alteryx and publish the .tde file to the server my dashboard updates. :)
I would like to publish twb, enabling "dynamic" parameter values in Tableau through alteryx. I can download the twb using the Tableau API, modify the xml but shouldn't publish back to server be possible using the API w/o tab cmd? So long as the workbook is small?
The steps seem very similar to Datasource publishing so I'm interested to know if what I'm proposing isn't possible before I dig into reverse engineering the datasource macro.
https://onlinehelp.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#Publish_Workbook
Hi @ephij,
I've recently created a 'Publish Tableau Workbook' macro that makes this possible and i've built an example video of your desired output here: https://twitter.com/benjnmoss/status/981488682753515520
The macro can be found here: https://gallery.alteryx.com/#!app/Publish-Tableau-Workbook/5ac4ee90826fd32cec14ef68
You would need to write your xml out of alteryx as a .twb file and then use the block until done to then use this tool to push the workbook to server.
I plan on publishing a blog highlighting this usecase over the next week.
Ben
Hi Ben,
Really this macro is awesome. It is publishing any twbx workbook to the server with the desired name.
But I am facing one issue while publishing .twb workbook. Its giving below error:-
"Error: Publish Tableau Workbook (6): Tool #65: Tool #4: Tableau Server API Request (Commit Workbook) Error Code 400011: Bad Request -- There was a problem publishing the file '9159:34A33380D32F420B90A1B31B869C6DC9-1:1'."
I will be very grateful to you if you can help me on this.
Thanks,
Sumit