--- title: "Tableau" slug: "tableau" description: "Create secure, reliable, and easy data pipelines. Get your data to Tableau with Dataddo for data analysis & quick dashboards. Get help with your configuration." updated: 2023-11-20T09:27:16Z published: 2023-11-20T09:27:16Z --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt > Use this file to discover all available pages before exploring further. # Tableau (Prerequisites) Please make sure you have installed - Tableau Desktop minimum version of **2023.1**, and - the [Dataddo connector plug-in](/docs/tableau#install-the-dataddo-connector-plugin). **Tableau** is a powerful data visualization and business intelligence software that allows users to create interactive and dynamic dashboards, reports, and charts from various data sources. It simplifies the process of analyzing and presenting data, enabling users to gain valuable insights and make data-driven decisions. The Dataddo Tableau connector works **across all Tableau products** including Tableau Desktop, Tableau Server, Tableau Prep, and Tableau Catalog. The Dataddo Tableau connector is **extract-only**, it allows you to visualize your data and publish your analysis just like any other data source. However, this means that to **refresh data**, you either need to do it **manually** in [Tableau Desktop](/docs/tableau#configure-tableau-desktop) or use [Tableau Server](/docs/tableau#publish-to-tableau-server). ## Tableau Implementation Cheat Sheet Using Dataddo direct connection to Tableau might not be an optimal solution for all the cases (e.g. when you need to work with large volumes of data with >100K rows per flow or you need to perform complex SQL transformations). Check the table below to find the optimal implementation for your specific case. | Use case | Solution | | --- | --- | | Personal Dashboard | Use [Dataddo Connector Plug-in](/docs/tableau#in-tableau-desktop) | | Shared Dashboard | Use [Dataddo Connector Plug-in](/docs/tableau#in-tableau-desktop) and configure [Tableau Server](/docs/tableau#publishing-to-tableau-server) | | Shared Dashboard with complex or large data. E.g. Complex SQL transformations needed or more than 100K rows per table | First use a database such as [BigQuery](/docs/google-bigquery) or [Postgres](/docs/postgres) as your flow destination (each flow will represent a single DB table). Then use Tableau native connection to connect to the chosen database. | --- ## Create a New Flow to Tableau in Dataddo 1. Navigate to **Flows** and click on [**Create Flow**](https://app.dataddo.com/flow/new). 2. Click on **Connect Your Data** to add your ***sources***. Here, you can [blend](https://docs.dataddo.com/docs/data-blending) or [union](https://docs.dataddo.com/docs/data-union) your data. 3. Click on **Connect Your Data Destination** and navigate to the **Dashboarding Apps** tab to add your destination. 4. Check the **Data Preview** to see if your data is correct. 5. **Name** your flow and click on **Create Flow**. A window with configuration details will pop up. Follow the instructions to finish the setup **in your dashboarding app**. If you need to revisit the configuration details, simply go to the [**Flows**](https://app.dataddo.com/flows) tab and click on the **power outlet** icon. ## Configure Tableau Desktop ### Install the Dataddo Connector Plug-in 1. Check if your Tableau version is at least **2023.1**. If not, please update it. 2. [Download Dataddo Connector Plugin](https://ddo-prod-service-static-content-s3.s3.eu-west-1.amazonaws.com/installers/dataddo-1.0.0.taco) file. 3. Save the file to 1. For Mac: **~/Documents/My Tableau Repository/Connectors** 2. For Windows: **C:\Users[Windows User]\Documents\My Tableau Repository\Connectors**. 4. Restart your Tableau Desktop. ### Connect Your Data to Tableau After the initiation, you should be able to find **Dataddo by Dataddo** on the left-hand side under **Connect to a server**, under **More**. After saving your flow in Dataddo, a window with configuration details will appear. There, you will find the **Dataddo API Key**. 1. Open your Tableau Desktop and click on the [**Dataddo by Dataddo** connector](/docs/tableau#install-the-dataddo-connector-plugin) on the left side. 2. Insert your **Dataddo API Token/Key** and click on **Connect**. 3. All your data flows to Tableau will be automatically loaded. ## Publish Data to Tableau Server ### Configure the Tableau Server In order to enable publishing the data to Tableau Server you have to first install **the Dataddo Connector Plugin** to your Tableau server. Please follow these steps: 1. [Download Dataddo Connector Plugin](https://ddo-prod-service-static-content-s3.s3.eu-west-1.amazonaws.com/installers/dataddo-1.0.0.taco) file. 2. Save the file to 1. Windows Server: **C:\Program Files\Tableau\Connectors** 2. Linux: **/opt/tableau/connectors** ### Publish the Source to Tableau Server Please make sure that you are not using **Tableau Cloud** as it does not support Dataddo Connector. 1. In the Tableau Desktop, click on the **Server** tab and enter your **Tableau Server URL** and **credentials**. 2. Select **Publish Data Source**. 3. Change the authentication from None to **Embedded password** and click on **Publish**. ![Tableau - Publish to Server](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Tableau%20-%20Publish%20to%20Server.png) --- ## Limitations ### Number of Data Records When sending your data to Tableau, be aware that although it can handle a large amount of data, it **has a limit of how much data it can connect at once**. If you see an error or notice a significant decrease in performance and load time, it usually means that you have **too much data in your source** and the connection will experience **timeouts** due to the size. You can see how much data is in the source by clicking on **Data Preview** (three dots next to the source under [Sources](https://app.dataddo.com/sources)) and the total number of records is shown in the top left. **Solution:** 1. **Limit the amount of data**: especially if the data volume is larger due to incorrect [snapshotting settings](/docs/extraction#extraction-frequency). 2. Or **connect the data to a data warehouse or [Google Sheets](/docs/google-sheets-destination)** first and then to Tableau. ## Troubleshooting ### Cannot Use Tableau Bridge According to [Tableau's official documentation](https://help.tableau.com/current/online/en-us/to_sync_local_data.htm), only Web Data Connectors with a standard username and password authorization are supported for the automatic sync via Tableau Bridge. This, however, does not comply with our extensive security policy (using OAuth mechanism). Therefore, you have to use one of the following workarounds to archive data refresh: 1. Use the **Tableau Desktop [Refresh From Source](https://help.tableau.com/current/online/en-us/to_refresh_desktop.htm)** command, or run a **manual refresh** from Tableau Desktop. 2. Use an **intermediate data storage** so that Tableau Bridge directly connects to (e.g. [Google Sheets](/docs/google-sheets-destination), [BigQuery](/docs/google-bigquery), or MySQL). 3. Use **Tableau Server** and whitelist Dataddo WDC. ### Tableau Server Error When Refreshing Web Data Connector You might be experiencing the error **"Unknown Failure (status Code = 11000 Web data connector is not whitelisted)"** when refreshing Web Data Connector via Tableau Web Server. **To address this issue, please add Dataddo WDC to your safe list and secondary safe list.** 1. To add a connector to the safe list and secondary safe list, use the [tsm data-access web-data-connectors add](https://help.tableau.com/current/server/en-us/cli_data-access.htm#web-data-connectors-add) command, providing the name, safe list URL, and secondary safe list URLs. 2. You can also **manage WDCs** using the [web-data-connector-settings Entity](https://help.tableau.com/current/server/en-us/entity_wdc.htm). After running this command, you need to **apply your pending changes using the tsm pending-changes apply command**. A prompt will warn you that the command will restart the Tableau Server. If Tableau Server is currently running it will be restarted, and if it is stopped it will be left in a stopped state with no restart. ``` tsm data-access web-data-connectors add --name ""DATADDO WDC"" --url https://app.dataddo.com/utils/tableau/ --secondary https://app.dataddo.com/(.\*) ``` Find more details on [Tableau's official documentation](https://help.tableau.com/current/server/en-us/datasource_wdc.htm). ## Related Articles - [Direct Connection to Dashboarding Apps](https://docs.dataddo.com/docs/simple-data-integration-to-dashboards) - [Data Backfilling to Dashboarding Apps](https://docs.dataddo.com/docs/data-backfilling-to-dashboarding-apps) - [Data Transformations](https://docs.dataddo.com/docs/data-transformations) - [Data Quality Watcher](https://docs.dataddo.com/docs/data-quality-watcher)