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
In the window that opens, we're going to enter the web data connector URL. We'll walk through getting that URL in the next step...
Switch back to data.world and on the dataset, data file, Data Project, or query you'd like to import to Tableau, select Export > Tableau and copy the connector URL from the resulting window:
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 'Export > Tableau' menu, the data.world web data connector will be pre-populated with your dataset URL or query details. Note that the first time you use the connector, you'll be prompted to log into your data.world account:
That's it! Click Submit and the connector will grab all of the dataset tables, columns, and data types for that dataset and pull them into Tableau. If you'd like to bring in another dataset, you can go to Data > New Data Source and repeat the steps above.
Once you've created and published your viz 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) :
Here's an example Tableau embed with the corresponding markdown.
More on queries:
Note that we've recently added the ability to pull in a specific query via the web data connector. This is great for when you're working with really large files that may take a while to import via the connector, but you really only need a subset of the data. To import a query, just click on the Export > Tableau option from the query view in your workspace on your dataset or Data Project:
Again, copy the web connector URL from the popup:
And paste that in as the connector URL from Connect > Web Data Connector in Tableau and press enter:
See that we're passing in the dataset, query type (SQL or SPARQL), and the query you defined. Click submit to pull in the query results to Tableau.
As always, contact us if you have any feedback or run into any unexpected issues with the connector.