To connect to a data source in Tableau, select a connector, open or sign in to the source, and then choose the tables, sheets, or files that Tableau should use. The Data Source page lets you review the connection, combine related data, and choose between a live connection and an extract before building a worksheet.

What Is a Tableau Data Source Connection?

A Tableau data source connection defines where the data comes from and how Tableau accesses it. The source may be a local file, a database server, a cloud application, or a published Tableau data source.

A Tableau data source can contain more than the original connection details. It may also include related tables, joins, unions, field names, data types, calculations, filters, aliases, and extract settings.

Connecting data source in Tableau

File, Database, and Server Connections Supported by Tableau

Tableau provides connectors for several categories of data. The connectors available to you depend on the Tableau product, operating system, installed drivers, and permissions assigned to your account.

  • File-based data: Microsoft Excel workbooks, text and CSV files, JSON files, PDF tables, spatial files, and supported statistical files.
  • Relational databases: systems such as Microsoft SQL Server, Oracle, MySQL, PostgreSQL, and other supported databases.
  • Cloud platforms: supported cloud databases, warehouses, and business applications.
  • Tableau sources: published data sources and supported Tableau extract or workbook resources.

File connectors normally ask you to locate a file. Server connectors generally require a server name, authentication details, and sometimes a database, warehouse, role, or schema.

Connecting data source in Tableau

How to Connect Tableau to a Data Source

Use the following steps to create a basic connection in Tableau Desktop:

  1. Open Tableau Desktop.
  2. On the start page, locate the Connect pane.
  3. Select a listed connector, or choose More to view additional connectors.
  4. For a file connection, browse to the required file and open it.
  5. For a server connection, enter the requested server and authentication information, and then sign in.
  6. On the Data Source page, select the sheet, table, or other data object that you want to analyze.
  7. Drag additional tables to the data model when the analysis requires data from more than one table.
  8. Review field names, data types, and sample rows before opening a worksheet.
  9. Select a worksheet tab to begin creating a view.

From an open workbook, you can create another connection by selecting Data > New Data Source. The keyboard shortcut Ctrl + D may also open the connection interface on supported systems.

Connect to data source in Tableau

Configure Tables on the Tableau Data Source Page

After Tableau opens the connection, the Data Source page displays the available sheets, tables, or other data objects. Drag the required object onto the canvas to add it to the Tableau data model.

Use this page to check the following details before starting the analysis:

  • The correct file, database, schema, sheet, or table has been selected.
  • Column names are clear and accurately describe the data.
  • Fields have the expected text, number, date, date-time, Boolean, or geographic data types.
  • The preview contains the expected records and values.
  • Related tables have suitable matching fields.
  • Unnecessary fields and records are excluded when practical.

When you open a worksheet, connected fields appear in the Data pane. Tableau generally organizes fields as dimensions and measures and may also group them by table.

Relationships, Joins, and Unions in a Tableau Connection

When a Tableau data source uses multiple tables, select the combination method that matches the structure of the data.

Use Relationships Between Tableau Tables

A relationship connects logical tables through matching fields while allowing Tableau to determine how to combine them for each view. Relationships are useful when the tables have different levels of detail and should remain logically separate.

Use Tableau Joins for Row-Level Table Combination

A join combines columns from physical tables according to a join condition. Depending on the connector and data structure, you may use inner, left, right, or full outer joins. Check the resulting row count because an incorrect join can duplicate records or remove unmatched rows.

Use a Tableau Union to Append Rows

A union appends rows from one table to another. Use it for tables with compatible column structures, such as monthly files containing the same fields. Review the output when column names or data types differ between the tables.

Choose a Live Connection or Tableau Extract

For supported sources, Tableau may offer two connection modes:

  • Live connection: Tableau sends queries to the original source while you work. The view can reflect current source data, subject to caching, permissions, and source availability.
  • Extract: Tableau stores a snapshot of selected data in an optimized extract. The extract must be refreshed when you need to include later source changes.

A live connection may suit frequently changing data and centrally managed databases. An extract may be useful for offline work, reducing repeated queries to the original system, or limiting the data included in a workbook. The appropriate choice depends on data size, refresh requirements, performance, security rules, and access to the source.

Add Multiple Data Sources to a Tableau Workbook

A single Tableau workbook can use more than one data source. Select Data > New Data Source, connect to the additional source, and then choose the required source from the Data pane while editing a worksheet.

Do not confuse multiple data sources with multiple tables in one data source. Related tables from the same analytical model are often best configured together on the Data Source page. Separate data sources may be appropriate when the connections require different credentials, connection types, refresh schedules, or published resources.

Authentication and Permissions for Tableau Data Connections

Database and cloud connections require valid access to the underlying system. Depending on the connector, Tableau may request a username and password, an OAuth sign-in, an access token, or another authentication method.

  • Use an account that has permission to read the required tables or views.
  • Confirm that the server address, port, database, warehouse, schema, and role are correct.
  • Install the connector or database driver required by the data source.
  • Follow your organization’s rules for storing or embedding credentials.
  • Grant workbook users only the level of data access they require.

Troubleshoot a Tableau Data Source Connection

If Tableau cannot connect to the data source, check the error message and verify the connection in a logical order.

  • File not found: confirm that the file has not been moved, renamed, deleted, or disconnected from the computer.
  • Sign-in failure: verify the username, password, token, or OAuth account.
  • Server unavailable: check the server name, network connection, VPN, port, and firewall rules.
  • Missing driver: install the driver required for the selected database connector.
  • Table not visible: confirm the selected database or schema and verify that the account has permission to access the table.
  • Unexpected field values: inspect data types, joins, unions, filters, and source formatting.
  • Stale extract data: refresh the extract and check its refresh configuration.

Tableau Data Connection Review Checklist

  • Verify that Tableau is connected to the intended file, server, database, schema, and table.
  • Confirm that credentials and permissions provide access without exposing unnecessary data.
  • Check field names and correct any incorrectly detected data types.
  • Compare previewed values and row counts with the original data source.
  • Review relationship fields, join conditions, or unioned columns for mismatches.
  • Choose live or extract mode according to freshness and performance requirements.
  • Test the connection again after moving, publishing, or sharing the workbook.

Frequently Asked Questions About Tableau Data Sources

How do I connect an Excel file to Tableau?

Select the Microsoft Excel connector from the Connect pane, open the workbook, and drag the required worksheet or named range onto the Data Source canvas. Review the fields and then open a worksheet.

Can one Tableau workbook connect to multiple data sources?

Yes. Use Data > New Data Source to add another connection. You can then select the required data source from the Data pane while working in a worksheet.

What is the difference between a live connection and an extract in Tableau?

A live connection queries the original source during analysis, while an extract uses a stored snapshot of the selected data. Extracts must be refreshed to include changes made in the original source.

Why does Tableau require a database driver?

A driver enables Tableau to communicate with a particular database system. If the required driver is unavailable or incompatible, Tableau may not be able to establish the connection.

Summary of Connecting Tableau to a Data Source

Start by choosing the correct file, server, cloud, or Tableau connector. Authenticate when required, select the relevant tables, validate fields and data types, and configure relationships, joins, or unions carefully. Before building visualizations, decide whether the workbook should query live data or use a refreshable extract.