CODEWITHSUNDEEP
pythonpandasautomationtableau-api
p_sutherland
p_sutherland

Reputation: 491

Pull data from Tableau Server into Pandas Dataframe

My goal is to join three datasources that are only available to me through Tableau Server (no direct database access). The data is too large to efficiently use Tableau's Data Blending.

One way forward is to pull the data from the three Tableau Server Datasources into a Pandas dataframe, do the necessary manipulations, and save down an Excel File to use as a datasource for a visualization in Tableau.

I have found lots of information on the TabPy module that allows one to convert a Pandas dataframe to a Tableau Data Extract but have not found much re: how to pull data from Tableau server in an automated fashion.

I have also read about tabcmd as a way of automating tasks, but do not have the necessary admin permissions.

Let me know if you need further information.

Upvotes: 0

Views: 6447

Answers (2)

Will Ayd
Will Ayd

Reputation: 7164

You can use pantab to both read and write from Hyper extracts https://pantab.readthedocs.io/en/latest/

Upvotes: 1

Sam M
Sam M

Reputation: 4166

Tabcmd does not require admin privileges. Anyone with permissions to Server can use it, but it will respect the privileges you do have. You can install tabcmd on computers other than your server without needing extra license keys.

That being said, it's very simple to automate data downloading. Take the URL to your workbook and add ".csv" to the end of it. The .csv goes at the end of the URL, not any query parameters you have.

For example: http://[Tableau Server Location]/views/[Workbook Name]/[View Name].csv

Using URL parameters, you can customize the data filters and how it looks. Just make sure you put the .csv before the ? for any query parameters.

More info for this plus a few others hacks at http://www.vizwiz.com/2014/03/the-greatest-tableau-tip-ever-exporting.html.

Upvotes: 2

Related Questions