Skip to main content

Tableau Desktop Connector

Easily pull data directly into Tableau to create your visualizations using data.world's Tableau Desktop connector. By using the connector as your data source, Tableau can even keep the data in sync with data.world to ensure your visualizations are using the most accurate data.

Enable Tableau Desktop or Tableau Public on data.world

If you're connecting Tableau Desktop or Tableau Public to data.world for the first time:

  • Click the Integrations link at the bottom of the left sidebar in data.world

    integrations01.png

  • Filter or scroll down to find the Tableau Desktop/Public tile and click on it

  • Click the Enable Integration button at the top of the Tableau Desktop/Public integration page

Alternatively, you can enable the integration by following this link to go straight to the Tableau Desktop/Public integration page

Add a new data source in Tableau

To use the connector from Tableau Desktop or Tableau Public v.10+, select the Web Data Connector option under Connect > To a Server within your Tableau application.

In the window that opens, we're going to enter the web data connector URL.

The URL you enter here will depend on what type of import you would like to make. You have two options:

  1. Import all tables from a dataset or project

  2. Import a single table, file, or query result

Import an entire dataset

  1. Enter tableau.data.world as the Web Data Connector URL.

  2. Press Enter

  3. Login with your data.world credentials if prompted

  4. Enter the data.world dataset URL or click Browse to scroll through your datasets or search the data.world community (note that searches results are limited to 30 in the Web Data Connector)

  5. Click Select next to the dataset you'd like to import

  6. Click Connect to confirm you selection

  7. Depending on the size of the dataset, this import can take from a few seconds to a few minutes

Import a single file, table, or query result

Go to data.world and navigate to the file or query you would like to open in Tableau. To the right of the Download link, click Open with Tableau (note: if you have multiple integrations enabled, you may have to click the dropdown menu here to choose Tableau)

tableau01.png

Copy the URL from the new window that opens:

tableau04.png

Returning to Tableau, paste the connector URL into the input box. Note that when you enter the URL, the input box disappears and moves to the URL field so you'll just need to hit Enter on your keyboard to load the next page.

tableau05.png

By using the connector URL from the Open with Tableau window, the data.world web data connector will be pre-populated with your dataset URL or query details:

115018236988-mceclip5.png

If you'd like to bring in another dataset, you can go to Data > New Data Source and repeat the steps above.

Posting a Tableau visualization on data.world

Once you've created and published your visualization to Tableau Public, use the published URL to share it back on data.world as an Insight on a Data Project, as a discussion post, or within your dataset or Data Project summary using the markdown syntax @(https://public.tableau.com/shared/url) :

115003214833-mceclip0.png

Adding data.world to the Tableau Server safe list

In order to publish a Web Data Connector to Tableau Server to allow for data refreshes, you will need to add data.world to the safe list/allowlist. For general information on this, please see Tableau's documentation.

For Tableau Server 2018.1 and above, run the following commands:

tsm data-access web-data-connectors add --name 'DW WDC' --url https://tableau.data.world:443 --secondary https://api.data.world/*,https://query.data.world/*,https://data.world/oauth/*
tsm data-access web-data-connectors allow
tsm restart

As always, contact us if you have any feedback or run into any unexpected issues with the connector.

In this section: