Easily pull data directly into Tableau to create your visualizations using data.world's web data 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. Follow the instructions below, or checkout our video tutorial here: How to pull data into Tableau
Enable the Tableau integration in data.world
If you're connecting to Tableau and data.world for the first time:
- Click the Integrations link at the bottom of the left sidebar in data.world
- Filter or scroll down to find the Tableau tile and click on it
- Click the Enable Integration button at the top of the Tableau integration page
Alternatively, you can enable the integration by following this link to go straight to the Tableau integration page
Add a new Web Data Connector data source in Tableau
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:
- Import all tables from a dataset or project
- Import a single table, file, or query result
Import an entire dataset
- Enter tableau.data.world as the Web Data Connector URL.
- Press Enter
- Login with your data.world credentials if prompted
- 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)
- Click Select next to the dataset you'd like to import
- Click Connect to confirm you selection
- 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)
Copy the URL from the new window that opens:
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.
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:
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) :
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
As always, contact us if you have any feedback or run into any unexpected issues with the connector.