Easy and quick way to read data from published Tableau file to Dataframe using Python
This is an easy and quick trick to read Tableau data directly in Python code.
No need to install fancy packages, just using basic Python pre-installed Pandas. I tried many methods and packages, such as pantab, dataextract, etc., but this is by far the simplest and fastest way to get the job done, in 3 steps.
Step 1
Click on the download icon on the bottom right corner. Make sure the Tableau file needs to be downloadable. If you see something like this pop up, you are in good shape.
If you see Data or Crosstab buttom greyed out, that means the dashboard designer did not want to share the data file, and you are not able to scrape data using this method.
Step 2
Click Data, and you will land on the following page. Right click the link and then click Copy Link Address.
Step 3
Go to your favorite python editor, add .csv to the end of the URL just copied. Then you can read the data just using read_csv.
This method is purely inspired by the link below:
