The Data Source page is an important part of Tableau Desktop where users connect to data, inspect records, organize tables, modify field properties, and prepare information for analysis. Before creating worksheets, charts, and dashboards, it is useful to understand how the Data Source page works and how its different sections help manage data.
Learn more: JustAcademy Tableau Training | Register for a Tableau Course Demo
The Data Source page is the workspace in Tableau where you configure how Tableau connects to and interprets your source data. It appears after you establish a data connection, and you can return to it by selecting the Data Source tab in an open workbook.
On this page, you can review your data, add tables, create relationships, join or union tables, rename fields, change data types, hide unnecessary fields, and make other adjustments before beginning visual analysis.
Suppose you have an Excel file containing sales information with fields such as Order ID, Order Date, Customer Name, Region, Product, Sales, and Profit. You can use the Data Source page to check these columns, verify their data types, and prepare the dataset before creating a sales dashboard.
Note: The exact layout and available options can vary depending on the Tableau version and the type of data source.
The Data Source page generally contains four main areas: the left pane, canvas, data grid, and metadata grid. Their availability and appearance can vary for some connection types.
| Section | Purpose | Common Uses |
|---|---|---|
| Left Pane | Displays connection information and available tables or sheets. | Review connections, browse tables, add connections. |
| Canvas | Provides an area to organize tables and define how they relate. | Create relationships, joins, and unions. |
| Data Grid | Displays fields as columns and records as rows. | Inspect values, rename fields, sort data, create calculations where supported. |
| Metadata Grid | Displays information about fields, typically with one field per row. | Review field properties, rename fields, hide fields. |
The left pane displays details about the connected data source. The information shown depends on the type of connection.
If you connect to an Excel workbook named Sales_Report.xlsx, the left pane can show the workbook and its available sheets, such as Orders, Customers, and Products.
The canvas is the area where you place tables and configure how Tableau uses them together. For many file-based and relational data sources, the canvas has two conceptual layers: the logical layer and the physical layer.
The logical layer is the default view of the canvas. It allows you to create relationships between tables without immediately merging them into a single physical table.
Example: You can place an Orders table and a Customers table on the logical canvas and relate them using Customer ID.
The physical layer lets you define joins and unions between tables within a logical table. To access it, double-click a logical table on the canvas.
Example: You can join Orders and Order Details using Order ID when the data structure and intended analysis require a physical join.
| Feature | Logical Layer | Physical Layer |
|---|---|---|
| Main purpose | Defines relationships between logical tables. | Defines joins and unions within a logical table. |
| How to access | Shown by default for many supported data sources. | Double-click a logical table. |
| Data handling | Tables remain separate in the logical model. | Tables are combined according to the configured join or union. |
| Typical use | Working with related tables that have different levels of detail. | Building a single table from records or columns across tables. |
The data grid displays data as rows and columns. It helps you inspect the actual values stored in the selected table and review how fields appear before using them in a worksheet.
The data grid commonly shows a preview of the first 1,000 rows. It is a preview, so do not assume that every record in a large dataset is visible at once. In the logical layer, the grid displays data for the selected table; in the physical layer, it displays the merged result of the configured joins or unions.
| Order ID | Region | Product | Sales |
|---|---|---|---|
| 1001 | North | Laptop | 50000 |
| 1002 | South | Mobile | 20000 |
| 1003 | West | Monitor | 12000 |
By examining this grid, you can verify whether Order ID is recognized correctly, Region contains consistent labels, and Sales is stored as a numeric field.
The metadata grid displays information about the fields in your data source, usually with one field per row. It is particularly useful when you need to manage many columns or review field properties.
| Field Name | Meaning | Possible Action |
|---|---|---|
| Cust_ID | Customer identifier | Rename to Customer ID. |
| Ord_Date | Order date | Verify the Date data type. |
| Sales_Amt | Sales amount | Rename to Sales and verify numeric type. |
| Internal_Notes | Internal notes field | Hide it if it is not needed for analysis. |
Hiding a field from Tableau's view does not necessarily delete it from the original file or database.
After connecting to a file or database, you can select tables or sheets and place them on the canvas. The available options depend on the connector and the data source.
A relationship connects logical tables through matching fields while allowing Tableau to determine how to combine data for a particular view. Relationships are the default method for combining tables in many modern Tableau data models.
An Orders table contains Order ID, Customer ID, and Sales. A Customers table contains Customer ID, Customer Name, and City. A relationship using Customer ID allows Tableau to analyze orders alongside customer information.
Do not assume that similarly named fields always represent the same information. Verify the meaning and quality of the keys before creating a relationship.
A join combines columns from two or more tables based on a matching condition. Depending on the join type and matching records, it can retain or exclude rows from either table.
| Join Type | General Meaning |
|---|---|
| Inner Join | Returns records with matching keys in both tables. |
| Left Join | Returns all records from the left table and matching records from the right table. |
| Right Join | Returns all records from the right table and matching records from the left table. |
| Full Outer Join | Returns records from both tables, matching them where possible. |
A union appends rows from similarly structured tables. For example, sales data from January and February can be combined into a single table when the columns are compatible.
| Feature | Join | Union |
|---|---|---|
| Combination direction | Typically combines columns. | Typically appends rows. |
| Matching requirement | Uses a matching condition or key. | Uses compatible column structures. |
| Example | Orders combined with Customer Details. | January Sales appended to February Sales. |
The Data Source page lets you adjust field names and data types so that your data is easier to interpret and use in analysis.
| Field | Expected Type | Reason |
|---|---|---|
| Customer Name | String | Contains text. |
| Sales | Number | Supports numeric aggregation. |
| Order Date | Date | Supports date-based analysis. |
| Quantity | Integer | Represents a whole-number count. |
Tableau supports different ways to access data, including live connections and extracts. The options available depend on the connector and Tableau product.
| Feature | Live Connection | Extract |
|---|---|---|
| How data is accessed | Queries the connected source as needed. | Uses a stored snapshot of data. |
| Data freshness | Depends on the source and when queries run. | Depends on the most recent extract refresh. |
| Typical benefit | Can reflect recent source changes without refreshing an extract. | Can support performance and offline or portable analysis scenarios. |
| Important consideration | Performance depends on the source system and query workload. | Data can become outdated if the extract is not refreshed. |
When an extract is used, the Data Source page may provide a refresh option near the connection area. Follow the refresh options available for your specific source and environment.
Objective: Use the Data Source page to inspect and prepare a sample sales dataset before creating a visualization.
| Order ID | Order Date | Region | Product | Sales |
|---|---|---|---|---|
| 1001 | 2026-01-05 | North | Laptop | 50000 |
| 1002 | 2026-01-10 | north | Mobile | 20000 |
| 1003 | 2026-02-12 | South | Tablet | 15000 |
| 1004 | 2026-02-15 | West | Monitor | 12000 |
You will understand how to navigate the Data Source page, inspect a dataset, review field properties, and prepare data for a basic Tableau visualization.
| Problem | Possible Cause | Suggested Solution |
|---|---|---|
| Expected table is not visible. | Wrong file, database, schema, or sheet selected. | Review the connection and browse the available tables or sheets. |
| Numbers are treated as text. | Incorrect type detection or invalid characters. | Inspect the values and correct the field's data type where appropriate. |
| Dates appear incorrectly. | Inconsistent date formats or incorrect type detection. | Verify the source format and convert the field to the correct date type. |
| Totals change after joining tables. | Duplicate keys or an unsuitable join condition. | Check the join keys, row counts, and expected totals. |
| Data grid does not show all records. | The grid displays a preview rather than the entire dataset at once. | Remember the preview limitation and validate the full dataset using appropriate checks. |
| A field is not available for a particular action. | The data source type or connection mode may not support that action. | Review the connector's supported features and available Tableau options. |
The Data Source page is the workspace used to connect to, inspect, organize, and prepare data before building visualizations.
The main areas are the left pane, canvas, data grid, and metadata grid, although the layout can vary depending on the data source.
The left pane displays connection details and available tables or sheets, and it can provide options for adding connections.
The canvas is used to organize tables and define how they are related or combined.
The logical layer defines relationships between tables. The physical layer defines joins and unions within a logical table.
The data grid displays fields and data values so that users can inspect and make supported adjustments to their data source.
The metadata grid lists fields as rows and supports field-level tasks such as renaming and hiding fields.
Yes. Tableau supports renaming fields and changing data types for supported data sources.
A relationship connects logical tables while preserving their separate structure. A join physically combines tables according to a matching condition.
Checking data helps identify missing values, incorrect data types, duplicate records, and other issues that could lead to misleading visualizations.
The Data Source page is the foundation for preparing data in Tableau. By understanding the left pane, canvas, data grid, and metadata grid, you can organize tables, manage field properties, configure data relationships, and inspect your records before creating visualizations. Careful preparation and validation help make your Tableau worksheets and dashboards more accurate and reliable.
Continue learning with JustAcademy Tableau Training or Register for a Tableau Course Demo.
