Downloading tableau workbook from tableau server with data

Question

I am new to using tableau server. I wanted to know if it was possible to download a tableau workbook (which is linked to a live SQL DB) with the data from the tableau server? Basically I would want to have a downloaded packaged tableau file which I can pass around for demos, without having to connect to the database every time.

The best thing to do in this case is to connect to your SQL DB, publish the datasource to the server, and then when you dowwload it is will be a .twbx packaged file which you can share around since the datasource will be with it. — damiendonnelly, Feb 22 '15 at 01:30

score 6 · Answer 1 · answered Apr 01 '18 at 14:21

You can do this programmatically in python simply. TSC(Tableau Server Client) is the python library for tableau server. You can publish, update, delete and download workbooks freely using TSC Please visit https://github.com/tableau/server-client-python/blob/master/docs/docs/api-ref.md On this page, just search by "workbooks.download", then you will get the instructions how to download a workbook with data extraction.

score 1 · Answer 2 · answered Dec 12 '13 at 00:00

1

In essence, no. Since the workbook is using a live connection, the data is still on the SQL database and not on Tableau Server.

If you want to be able to create a packaged workbook for demo use, then you'll have to create an extract of the data that can be saved with the workbook.

answered Dec 12 '13 at 00:00

Talvalin

7,789
2
30
40

I like that this answer emphasizes the live DB connection will be broken, but an extract should work fine for just demo purposes. – Kara_F May 27 '16 at 18:39

score 1 · Answer 3 · answered Jul 15 '14 at 05:45

There is another approach to this problem. Now that the viz is using the tableau online extract. 1.Download the workbook from the server. 2.Once done, open the dashboard in tableau desktop. You will see a data extract with a check mark on it. 3.Right click on the data extract and click on create a local copy. 4.This will extract all the data so far and stores it locally. 5.Next step is to replace the datasource from the Online extract to the local copy you have created. 6.Save the workbook as .twbx.

You are done. Hope this will work for you..

score 1 · Answer 4 · answered Jul 01 '15 at 04:13

I believe what you are trying to do can be accomplished using a tableau extract. This will create a package of the sql db you want on the tableau server. the user could then make a packaged workbook or make a local copy of the extract.

http://kb.tableau.com/articles/knowledgebase/working-with-tableau-data-extracts

score 0 · Answer 5 · answered Jan 23 '14 at 02:10

0

Yes, you can from the top tight hand corner of the view depending on your user permission levels. Download Button

answered Jan 23 '14 at 02:10

damiendonnelly

372
3
4

1

Downvoted. The OP stated that the requirement is to download a workbook with a live connection as a packaged workbook, such that connecting to the database is not required. This is not possible unless the required data has been extracted prior to publishing the workbook to Tableau Server. – Talvalin Jan 30 '14 at 10:58
He said linked to a live SQL database, not published to server via a live connection. It is true that you need to create an extract, but if it is partially updating off a live database then it is still linked to a live SQL database, just that the twb file is connected to a tde on the Tableau server, which is extracted as a twbx when you download. – damiendonnelly Mar 10 '14 at 01:00

score 0 · Answer 6 · answered Jun 02 '17 at 09:55

0

When you connect tableau server data source click on extract then publish your workbook to server. when any one click on download the extracted data will also download along with worksheet

answered Jun 02 '17 at 09:55

Mehul Katara

907
11
32

score 0 · Answer 7 · answered Jan 16 '18 at 03:16

0

you must have the permission to download.at least Interactor

click "download", then save the workbook as "twbx" file to include data in the package file.

if your permission is "viewer", you cannot download tableau reports.

answered Jan 16 '18 at 03:16

honglin zhang

1,497
1
10
8

score 0 · Answer 8 · answered Feb 09 '18 at 12:51

one more thing you could do is. open workbook on server>>>>click download>>>>>select data>>>>go to full data>>> select show all column>>> download all row as text file

now download the workbook create a new data source with a text file you just downloaded. select create an extract

after completion, select replace data source

and it's done.

score 0 · Answer 9 · answered Mar 15 '18 at 14:13

Unfortunately you cannot unless you have the credentials for the live db connection, if you do you can download the workbook and create a local copy of the data source by entering the credentials and then extract the data which will store the data locally. This will improve the performance as well as then you will be using Tableau extract which is optimized for reporting

score 0 · Answer 10 · answered Apr 23 '18 at 06:08

With a live connection you will not be able to download the data with a Tableau workbook. For this you can follow this pocedure :

Create an extract connection in your workbook and publish it in the server with an refresh schedule to it (As per you Data updates). Now whenever you download the workbook it will come with the last refreshed data with it.

Hope it helps :)

score 0 · Answer 11 · answered May 10 '18 at 07:31

0

make the data connection as extract, then it will copy with data copy in dashboard.

answered May 10 '18 at 07:31

Mohammed Mohsin

21
1

score 0 · Answer 12 · answered Jul 01 '19 at 08:23

Download your workbook.
Edit your data Sources
Right-click Data Source and select "Create Local Copy"
Select the original data source .. right click it and replace it with the local copy
Lastly, right-click the original data source and close it.

There you have your workbook with a local extract(tde) You can refresh this local extract anytime you want by refreshing the data source.

score 0 · Answer 13 · answered Jul 16 '19 at 06:32

You can do so by using tableau extract file(.twbx) But if the workbook has large data and can't create extract locally, then we can use something called empty extract.

Here's how https://www.tableau.com/about/blog/2013/9/easy-empty-local-extracts-25152

Make an empty extract using above method and load it on server. Let server build the full extract and then download it. You are good to go with that workbook.

score 0 · Answer 14 · answered Jul 06 '22 at 07:34

Since the workbook is using a live connection, the data is still on the SQL database and not on Tableau Server.

If you want to be able to create a packaged workbook for demo use, then you'll have to create an extract of the data that can be saved with the workbook. Create an extract connection in your workbook and publish it in the server with an refresh schedule to it (As per you Data updates). Now whenever you download the workbook it will come with the last refreshed data with it.

score 0 · Answer 15 · answered Aug 11 '22 at 12:20

0

You can save it as a .twbx or download from the published version

answered Aug 11 '22 at 12:20

DepthVader

1

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Albert Logic Einstein Aug 23 '22 at 14:50

Downloading tableau workbook from tableau server with data

15 Answers15