Skip to main content

Tableau Authentication Credentials

Generate a personal access token (PAT) for your Tableau account.
Create a New Personal Access Token
Create a New Personal Access Token

Create a New Personal Access Token.

Creating the Connector in TextQL

Navigate to the TextQL 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.
Setting up a new Tableau Connector—Credentials form

Setting up a new Tableau Connector—Credentials form.

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.”
Tableau server

Identify your Server and Site using the Tableau Server URL.

If TextQL is self-hosted and your Tableau Server is on a private address, an administrator must allow it first; see Self-hosted Tableau Server on a private network. Tableau Cloud needs no change. 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.

Self-hosted Tableau Server on a private network

If your Tableau Server listens on a private address, such as an internal load balancer or a hostname that resolves to an RFC 1918 IP, the connector fails with destination blocked by egress policy. TextQL refuses connections to private, loopback, and link-local addresses by default, because a connector that accepts an arbitrary URL is otherwise an easy way to reach cloud metadata endpoints. For self-hosted TextQL, an administrator can allow the server in the Helm values:
ssrfTrustedHosts accepts comma-separated hostnames and wildcards such as *.internal.example.com, and forgives private IPs only: never loopback, link-local, or cloud metadata addresses. ssrfAllowedCIDRs accepts comma-separated CIDRs and is a raw IP range bypass with no such guard, so a range covering loopback, link-local, or metadata addresses (127.0.0.0/8, 169.254.0.0/16, 100.100.100.200) reopens exactly those endpoints for the whole deployment, including member-supplied connector URLs. Prefer ssrfTrustedHosts; if you must allow a network, keep the CIDR as narrow as possible. Both are deployment-wide, not per connector, and set the compute engine’s SSRF_TRUSTED_HOSTS and SSRF_ALLOWED_CIDRS environment variables. Redirects to another host are refused, so the Server you configure must be the final host. If Tableau redirects sign-in elsewhere, point the connector at the redirect target directly: credentials are never followed across hosts.

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.
Tableau sync

Collections are groups of views and published datasources

Click “New collection” in the top right.
Tableau sync

All of the projects scoped under the provided PAT token.

Select a project.
Tableau sync

All of the workbooks inside the selected project.

Select a workbook.
Tableau sync

All of the views inside the workbook, along with linkable published datasources.

NOTE: Tableau datasources connected to TextQL must be Extract. Querying from Live datasources is still in development.
Select one or more views.
Tableau sync
Select one or more datasources.
Tableau sync
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.
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.

Chatting with your dashboards

Once your Tableau connector is set up and synced, you can start chatting with your dashboards. Navigate to TextQL Chat to begin asking questions about your Tableau data. Hover over the ”+” icon and Click “Attach Tableau”.
Tableau sync
Choose the connector you just made.
Tableau sync

List of tableau connectors

Choose the collection you just made.
Tableau sync

List of collections for this connector

Click “Attach Collection”.
Tableau sync

One collection per chat

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

Just send a chat!

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.
Connected apps pane in Tableau

Connected apps pane in Tableau.

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.
Form for creating connected apps in Tableau

Form for creating connected apps in Tableau.

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

Generate a New Secret.

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.