Open navigation

How to connect data to Tableau

Using the Query Manager, you can easily create queries and connect your data from various data sources to Tableau with the Supermetrics API.


Before you begin

Tableau Desktop Tableau Server Tableau Online

The Supermetrics Web Data Connector is compatible with Tableau Desktop version 10.2 or later. Trying to open a connector with an incompatible version may show the following error:


The version of Tableau that you are using cannot use the web data connector that you are trying to access. The connector requires at least version 'x.x' of the web data connector API.


See Tableau documentation to learn more about web data connectors in Tableau Desktop.


Instructions

  1. Log in to the Supermetrics Hub.
  2. In the sidebar, click API.
  3. Select for Supermetrics API from the dropdown menu next to the page title.
  4. Click Select data source.
  5. Select a data source and connection to use. 
  6. In the sidebar on the left, build your query. Click Run to test it and review your data in the preview.
  7. From the URL format options, select Tableau.
  8. Copy the Query URL.

    The query URL includes an API key that gives anyone with the URL access to your data. Treat this as you would a password and keep it safe. If you need to share the URL publicly, use the Short URL option that does not display your API key.

  9. In Tableau, navigate to Connect → Web Data Connector. The option can be found under the To a Server section.
  10. In the web data connector window that opens, insert supermetrics.com/tools/tableau into the URL field and press Enter to continue.
  11. In the Supermetrics Web Data Connector view, paste the Query URL you copied from the Query Manager in step 7, and optionally, fill in a name for the table in Tableau.
  12. Click Get data.


The data from your query will start to populate in Tableau.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.