Tableau Course
Data Source Filters
A data source filter restricts which rows enter Tableau at the very first step — before any worksheet, any view filter, and any calculation ever sees the data. Rows that don't pass the filter simply don't exist in the workbook.
Where Data Source Filters Sit in the Filter Order
Tableau applies filters in a fixed execution order. Data source filters are at the very top — they execute first, before everything else. Rows removed here are never loaded into memory and never passed to any other filter, calculation, or chart in the workbook.
Adding a Data Source Filter
Data source filters are configured on the Data Source tab — not in a worksheet. This distinction is important: they apply globally across every single worksheet in the workbook, not just the one you are currently building.
Data Source Tab — Filters Panel Mockup
Data Source Filters vs Worksheet Filters
| Aspect | Data Source Filter | Worksheet Filter |
|---|---|---|
| Where configured | Data Source tab | Filters shelf in a worksheet |
| Scope | All worksheets in the workbook | The current worksheet only (unless applied to all) |
| Execution order | First — before anything else | After context filters |
| Performance impact | Reduces data loaded — speeds up the whole workbook | Data is still loaded — filtering happens after load |
| Visible to viewer | No — hidden at the connection level | Can be shown as an interactive filter control |
Data Source Filters on Extracts
Data source filters are especially powerful when combined with extracts. When you set a data source filter and then create an extract, Tableau applies the filter before building the .hyper file. This means the extract only contains the rows that pass the filter — the excluded rows are never written to disk at all. The result is a smaller, faster .hyper file.
For example: if your source has 5 years of transaction data but your workbook only needs the last 2 years, adding an Order Date data source filter before extracting can reduce a 10 million row extract down to 4 million rows — cutting both extract creation time and query time significantly.
Editing and Removing Data Source Filters
To edit or remove an existing data source filter, return to the Data Source tab and click Edit next to the Filters label. The Edit Data Source Filters dialog lists all active filters. Click Edit on any filter to change its conditions, or click the Remove button to delete it. Removing a data source filter immediately makes those rows available again across all worksheets.
Data source filters are one of the most important tools for keeping a workbook fast and secure. Fast because fewer rows means faster queries across every worksheet. Secure because sensitive rows — such as records belonging to other regions or business units — can be excluded at the source level, making them completely invisible to workbook users rather than just hidden behind a worksheet filter that a curious user could remove. In enterprise Tableau deployments, data source filters are often the first line of data access control before row-level security is implemented at the server level. Build the habit of checking whether your workbook actually needs all the rows in the source before you start building charts.
Practice Questions
1. Where in Tableau do you go to add a data source filter, and what do you click to start?
2. A data source filter is applied to a workbook with 8 worksheets. Which worksheets does the filter affect?
3. What happens when a data source filter is active at the time an extract is created?
Quiz
1. You want to exclude all rows older than 2022 from an entire workbook as efficiently as possible. Which filter type should you use?
2. Why do data source filters generally improve workbook performance more than worksheet filters applied to the same field?
3. How do you edit or remove an existing data source filter after it has been created?
Next up — Lesson 20: Metadata — understanding and managing field properties, descriptions, and comments inside Tableau.