> ## Documentation Index
> Fetch the complete documentation index at: https://docs.textql.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Tableau Connector

> Connecting Tableau to TextQL

### Tableau Authentication Credentials

Generate a personal access token (PAT) for your Tableau account.

<Frame>
  <img height="200" src="https://mintcdn.com/textql/SCCpxF12e_uUuhlJ/images/datasources/business-intel/create-pat-token-name.png?fit=max&auto=format&n=SCCpxF12e_uUuhlJ&q=85&s=98037b73a9e54086cc1cc33f2138ba38" alt="Create a New Personal Access Token" data-path="images/datasources/business-intel/create-pat-token-name.png" />
</Frame>

<Frame caption="Create a New Personal Access Token.">
  <img height="200" src="https://mintcdn.com/textql/SCCpxF12e_uUuhlJ/images/datasources/business-intel/create-pat-token-value.png?fit=max&auto=format&n=SCCpxF12e_uUuhlJ&q=85&s=1bff962ed40747471aa8b696386f9736" alt="Create a New Personal Access Token" data-path="images/datasources/business-intel/create-pat-token-value.png" />
</Frame>

### Creating the Connector in TextQL

Navigate to the [TextQL Connectors Page](/core/datasources/the-connectors-page) and click **Create New Connector**.  Then submit the creation form with Tableau selected.  This will open a form for entering the credentials for reaching your Tableau connected app.

<Frame caption="Setting up a new Tableau Connector—Credentials form.">
  <img height="200" src="https://mintcdn.com/textql/rgoo6-qFOQFVSBE4/images/datasources/tableau/tableau-connector.png?fit=max&auto=format&n=rgoo6-qFOQFVSBE4&q=85&s=98e9d42cd9aabd1785488264a7504ece" alt="Setting up a new Tableau Connector—Credentials form" data-path="images/datasources/tableau/tableau-connector.png" />
</Frame>

The **Connector Name** can be addressed without navigating from the TextQL site: this is a generic name used to identify what data is served from the connector. For Example, "Marketing Dashboards" or "Dashboards Central."

Next, identify and add the **URL of your Tableau Server,** for example `https://10ax.online.Tableau.com/#/site/textqldev/home`.  From the server url, you can additionally extract your

* **Server**: the base url, for example, `https://10ax.online.Tableau.com`, and your
* **Site:** which is found in the server url after the "site/," for example, "textqldev."

<Frame caption="Identify your Server and Site using the Tableau Server URL.">
  <img height="200" src="https://mintcdn.com/textql/SCCpxF12e_uUuhlJ/images/datasources/business-intel/tableau-server.png?fit=max&auto=format&n=SCCpxF12e_uUuhlJ&q=85&s=204b0d0b07771927790b1cb833290a6e" alt="Tableau server" data-path="images/datasources/business-intel/tableau-server.png" />
</Frame>

Finally, add the **PAT ID** and **PAT Value** obtained by following the steps above in the section **Tableau Authentication Credentials**.

When the form is complete, click **Create** to create and save your Tableau connector.

At any time, you can edit your Tableau connector credentials by selecting the connector from the Connectors Page and selecting edit from the actions dropdown. Note that when modifying an existing connector, the TextQL site will redact secrets.

### Syncing The Connector -- Add Your Dashboards

After setting up your Tableau connector, you'll need to select the dashboards
to be made available to Ana. To do this, click into your connector, and then select the projects you want to include.

<Frame caption="Collections are groups of views and published datasources">
  <img height="200" src="https://mintcdn.com/textql/3kdap-dSiw8NvQAY/images/datasources/business-intel/collections.png?fit=max&auto=format&n=3kdap-dSiw8NvQAY&q=85&s=22e996ff9b4e27e213d4dfb3e943865b" alt="Tableau sync" data-path="images/datasources/business-intel/collections.png" />
</Frame>

Click "New collection" in the top right.

<Frame caption="All of the projects scoped under the provided PAT token.">
  <img height="200" src="https://mintcdn.com/textql/3kdap-dSiw8NvQAY/images/datasources/business-intel/collection-cid.png?fit=max&auto=format&n=3kdap-dSiw8NvQAY&q=85&s=74ffd7d22cb8f16f96f75a2dc3e52ad9" alt="Tableau sync" data-path="images/datasources/business-intel/collection-cid.png" />
</Frame>

Select a project.

<Frame caption="All of the workbooks inside the selected project.">
  <img height="200" src="https://mintcdn.com/textql/rgoo6-qFOQFVSBE4/images/datasources/business-intel/workbooks.png?fit=max&auto=format&n=rgoo6-qFOQFVSBE4&q=85&s=60a83c3292390411a5adc336c45be0dd" alt="Tableau sync" data-path="images/datasources/business-intel/workbooks.png" />
</Frame>

Select a workbook.

<Frame caption="All of the views inside the workbook, along with linkable published datasources.">
  <img height="200" src="https://mintcdn.com/textql/3kdap-dSiw8NvQAY/images/datasources/business-intel/dsbuilder.png?fit=max&auto=format&n=3kdap-dSiw8NvQAY&q=85&s=ac22e4184f0f915e1f5f1a9344969484" alt="Tableau sync" data-path="images/datasources/business-intel/dsbuilder.png" />
</Frame>

<Note>
  NOTE: Tableau datasources connected to TextQL must be **Extract**.  Querying from **Live** datasources is still in development.
</Note>

Select one or more views.

<Frame caption="">
  <img height="200" src="https://mintcdn.com/textql/rgoo6-qFOQFVSBE4/images/datasources/business-intel/selviews.png?fit=max&auto=format&n=rgoo6-qFOQFVSBE4&q=85&s=36278e4fd73776d666aef7a84febbad5" alt="Tableau sync" data-path="images/datasources/business-intel/selviews.png" />
</Frame>

Select one or more datasources.

<Frame caption="">
  <img height="200" src="https://mintcdn.com/textql/3kdap-dSiw8NvQAY/images/datasources/business-intel/selds.png?fit=max&auto=format&n=3kdap-dSiw8NvQAY&q=85&s=0dbb8710c9b3b2799bfb89e0fc377f76" alt="Tableau sync" data-path="images/datasources/business-intel/selds.png" />
</Frame>

After you are done, click "Create Collection" in the bottom right.

### Refreshing a Collection

If your Tableau workbooks or datasources have changed since you created a collection, you can manually refresh it to pull in the latest views and datasources.

On the collections list, hover over a collection card and click the **Refresh** icon (circular arrow) in the top-right corner of the card. TextQL will re-authenticate with Tableau, fetch the current list of views and datasources, update the collection, and invalidate any cached introspection data.

<Note>
  The refresh re-syncs the views and datasources available in the collection. It does not change which project or workbook the collection points to. To change the scope of a collection, delete it and create a new one.
</Note>

## Chatting with your dashboards

Once your Tableau connector is set up and synced, you can start chatting with your dashboards. Navigate to [TextQL Chat](https://app.textql.com/chat/new) to begin asking questions about your Tableau data.

Hover over the "+" icon and Click "Attach Tableau".

<Frame caption="">
  <img height="200" src="https://mintcdn.com/textql/3kdap-dSiw8NvQAY/images/datasources/business-intel/newchat.png?fit=max&auto=format&n=3kdap-dSiw8NvQAY&q=85&s=f206f35b213cf790831c1b9163823304" alt="Tableau sync" data-path="images/datasources/business-intel/newchat.png" />
</Frame>

Choose the connector you just made.

<Frame caption="List of tableau connectors">
  <img height="200" src="https://mintcdn.com/textql/3kdap-dSiw8NvQAY/images/datasources/business-intel/attach-collection.png?fit=max&auto=format&n=3kdap-dSiw8NvQAY&q=85&s=b97ae10ed802cf57074067a501a8937f" alt="Tableau sync" data-path="images/datasources/business-intel/attach-collection.png" />
</Frame>

Choose the collection you just made.

<Frame caption="List of collections for this connector">
  <img height="200" src="https://mintcdn.com/textql/3kdap-dSiw8NvQAY/images/datasources/business-intel/pickcollection.png?fit=max&auto=format&n=3kdap-dSiw8NvQAY&q=85&s=ed865e1da3d1e999dd0bee55eaf60e7f" alt="Tableau sync" data-path="images/datasources/business-intel/pickcollection.png" />
</Frame>

Click "Attach Collection".

<Frame caption="One collection per chat">
  <img height="200" src="https://mintcdn.com/textql/3kdap-dSiw8NvQAY/images/datasources/business-intel/attachit.png?fit=max&auto=format&n=3kdap-dSiw8NvQAY&q=85&s=afa1a8710b0774b9c6127a10aa790948" alt="Tableau sync" data-path="images/datasources/business-intel/attachit.png" />
</Frame>

Ask Ana anything you want. She can see / filter the views in your collection, and run SQL and Python over your underlying datasources.

<Frame caption="Just send a chat!">
  <img height="200" src="https://mintcdn.com/textql/rgoo6-qFOQFVSBE4/images/datasources/business-intel/startingchat.png?fit=max&auto=format&n=rgoo6-qFOQFVSBE4&q=85&s=421a3408190b8bc0efb932df48ce7315" alt="Tableau sync" data-path="images/datasources/business-intel/startingchat.png" />
</Frame>

### Sharing Collections via Embed Links

Admins can generate embed links for Tableau collections. Embed links authenticate as service accounts (bot users) created in Settings → Service Accounts.

**Service accounts:**

* Are regular org members with RBAC-controlled permissions
* Default to "member" role (can read datasets, create chats)
* Don't expose admin credentials
* Can be deleted to revoke all associated embed links

To share a collection, click the link icon on a collection card and select which service account to use.

### Tableau Connected App (deprecated)

Generally, you will need to be a server / site administrator within your Tableau account to complete the following steps.

From within your Tableau account, navigate to **Settings** **> Connected Apps.** Then click the **New Connected App** dropdown and select **Direct Trust.**

<Frame caption="Connected apps pane in Tableau.">
  <img height="200" src="https://mintcdn.com/textql/SCCpxF12e_uUuhlJ/images/datasources/business-intel/tableau-connected-app.png?fit=max&auto=format&n=SCCpxF12e_uUuhlJ&q=85&s=eb3a695976452531af7eeefb01e9ac9d" alt="Connected apps pane in Tableau" data-path="images/datasources/business-intel/tableau-connected-app.png" />
</Frame>

A form will appear, asking you to enter a **Connected App Name**, and choose an **Access Level.** Note that the Access Level options determine the projects and dashboard that will become available in TextQL.  Finally, click **Create** to create the new connected App.

<Frame caption="Form for creating connected apps in Tableau.">
  <img height="200" src="https://mintcdn.com/textql/SCCpxF12e_uUuhlJ/images/datasources/business-intel/tableau-connected-apps-form.png?fit=max&auto=format&n=SCCpxF12e_uUuhlJ&q=85&s=3e516f31cceffc382171498df0540491" alt="Form for creating connected apps in Tableau" data-path="images/datasources/business-intel/tableau-connected-apps-form.png" />
</Frame>

Click into your connected app, and then click **Generate New Secret.**

<Frame caption="Generate a New Secret.">
  <img height="200" src="https://mintcdn.com/textql/SCCpxF12e_uUuhlJ/images/datasources/business-intel/tableau-secret.png?fit=max&auto=format&n=SCCpxF12e_uUuhlJ&q=85&s=1416246aae2b20bf78c70fd3f6afc23e" alt="Generate a New Secret" data-path="images/datasources/business-intel/tableau-secret.png" />
</Frame>

This action will provide you with:

* **App / Client ID**
* **Secret Value**
* **Secret ID**

This authentication method is deprecated, so reach out to a TextQL admin to continue.
