Why is Tableau Not Showing All Data?

It's one of the most common moments of frustration for analysts: you've connected your data, you start building a beautiful visualization in Tableau, but the numbers don't look right. You quickly realize that rows you know should be there have simply vanished. This feeling of "my data is missing" can be a real roadblock, but the good news is that the cause is usually a simple setting you've overlooked rather than a serious error.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

This tutorial walks through the most frequent reasons why Tableau might not be showing all your data. We'll start with the most obvious culprits and work our way toward the trickier, less apparent causes, giving you a clear roadmap to find those missing records.

Check Your Filters First (The 90% Solution)

Before you start questioning your database or the integrity of your data file, always check your filters. A forgotten filter is, by far, the most common reason for missing data. This can happen in a few different places.

Worksheet and Dashboard Filters

These are the filters applied directly to the visualization you're working on. You might have added one to focus on a specific time period or category and simply forgotten to remove it later.

• The Filter Shelf: Look at the "Filters" shelf on your worksheet. Do you see any pills there? Click on each one and select "Edit Filter" to see what rules are applied. Sometimes, you might have excluded specific values or set a date range that's now out of date.
• Quick Filters: If you're working on a dashboard, check for any Quick Filters that are visible and interactive. A teammate (or you, last Tuesday) might have clicked on a filter that is now hiding the data you're looking for.
• Action Filters: Dashboard actions, like "Use as Filter," can also create temporary filters. When you click on a mark in one view (e.g., a bar representing "Canada"), it filters other views on the dashboard. Check the "Actions" menu under the Dashboard or Worksheet tabs to see if an action is active. The easiest way to clear these is just to click the mark you previously selected to "un-filter" the view.

Data Source Filters

This is a more permanent type of filter that many users forget about. A data source filter is applied to the entire connection, meaning it removes data before it even reaches any of your individual worksheets. This is often done to improve performance or to set a baseline view for all reports in a workbook.

To check for these:

1. Go to the Data Source tab in the bottom-left corner of Tableau.
2. In the top-right corner of the data source page, look for the "Filters" link. Click it.
3. A dialog box will pop up, showing any filters applied at the data source level. You can edit or remove them from here.

For example, if a data source filter is set to [Region] = 'USA', you will never be able to see data from Europe or Asia in any worksheet that uses that data source, no matter how many times you adjust your worksheet filters.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Inspect Your Data Connections and Joins

If you've confirmed that no filters are to blame, the next place to investigate is how your data is being brought into Tableau. Issues with joins, unions, and the type of connection you're using can inadvertently cut out chunks of your data.

The Wrong Join Type Can Make Data Disappear

When you combine multiple tables, Tableau uses a join. The type of join you use determines which records are kept. An INNER JOIN is often the default, and it only keeps records that have a match in both tables. If a record in one table doesn't have a corresponding match in the other, it gets dropped entirely.

Imagine you have a table of Sales Reps and a table of Deals Closed. If you do an inner join, you will only see sales reps who have closed at least one deal. Your reps who haven't closed anything yet will be missing from your final table.

To fix this, you might need a different join type:

• Left Join: Keeps all records from the left table and any matching records from the right table. In our example, this would show you all your sales reps, with deal information present for those who have it and null values for those who don't.
• Right Join: Keeps all records from the right table. This would show all deals, even if the sales rep assigned to one somehow isn't in your main Sales Reps table.
• Full Outer Join: Keeps all records from both tables, regardless of whether they have a match. This is the most inclusive join.

You can change the join type by going to the Data Source tab, clicking on the Venn diagram symbol that represents your join, and selecting a different option from the menu.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Extract vs. Live Connection Mysteries

Tableau connects to data in two ways: via a Live connection or an Extract. Each has different behaviors that can lead to "missing" data.

Tableau Extract Problems

A Tableau Extract (.hyper file) is a snapshot of your data, stored locally for fast performance. The key word here is snapshot. If new data has been added to your original source, it will not appear in your workbook until the extract is refreshed.

• Stale Extract: The simplest problem is that your extract is just old. Right-click on your data source in the Data pane and select "Extract" > "Refresh" to pull in the latest data.
• Incorrect Settings: When you first create an extract, Tableau gives you several options. You can choose to extract 'All rows' or just the 'Top N rows'. Make sure your extract is configured to pull all the data you need. You might also have set up an "Incremental Refresh," which only adds new rows based on a specified field (like an ID or a date). If this is misconfigured, it might not be picking up on all the new records.

Live Connection Caveats

A live connection queries your database directly. While this means the data is always current, it also means that any performance optimizations, custom SQL, or views on the database side could be limiting what Tableau receives. The issue might not be in Tableau at all but in the SQL view you're connecting to.

Advanced Causes of Missing Data

If you've checked all of the above and are still tearing your hair out, a few less-common features could be the culprit.

Row-Level Security (RLS)

Row-Level Security is an advanced feature used to control which users can see which data. For instance, a sales manager for Germany can be set up to only see data for deals in Germany, while the VP of Sales sees everything. If RLS is enabled on your data source (either in Tableau or on the database itself), you might be intentionally restricted from seeing certain rows. Check with your data administrator to see if RLS is being applied to your user account.

The Data Interpreter

When connecting to Excel or Google Sheets files that are not perfectly formatted tables, Tableau's Data Interpreter does its best to guess where your data begins and ends. Most of the time, it's a lifesaver, cleaning up messy header rows and footers. Occasionally, however, it can misinterpret the file structure and accidentally cut off the top or bottom rows of your actual data. In the Data Source tab, try unchecking the "Use Data Interpreter" box to see if your missing rows suddenly appear.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Context Filters and Order of Operations

Tableau processes different types of filters in a specific order. Context Filters are applied very early in this process, before most other filters on your worksheet. In effect, they create a temporary, smaller version of your dataset that all other filters must work with. If a context filter is removing data, no other worksheet filter can bring it back. If you have any gray pills on your filter shelf, those are context filters. Try removing them from the context to see if that solves the issue (right-click the pill > "Remove from Context").

A Final Checklist to Find Your Missing Data

When data goes missing in Tableau, run through this checklist in order. You'll almost always find the culprit.

• Worksheet Filters: Check the Filters shelf on your current sheet.
• Dashboard Filters: Look for any interactive quick filters or filter actions on the dashboard view.
• Data Source Filters: Go to the Data Source tab and check for workbook-wide filters.
• Joins: Review your join types. Is an inner join excluding records that don't have a match?
• Extracts: If using an extract, perform a full refresh and check the extract's settings.
• Data Interpreter: If using a spreadsheet, try turning the Data Interpreter on or off.
• Row-Level Security: Ask your administrator if RLS is active for your user account.
• Context Filters: Check for gray pills on the filter shelf and test removing them from context.

Final Thoughts

Ultimately, uncovering why Tableau isn't showing all your data is a process of systematic troubleshooting. By starting with the most likely causes like filters and joins, and then moving to more nuanced settings like extracts and RLS, you can methodically identify and fix the issue without wasting hours in frustration.

We know that debugging complex BI tools can slow down the momentum of your analysis. That's why we built Graphed to be a more intuitive alternative. You can connect all your marketing and sales data sources with a few clicks, and instead of wrestling with menus and filter shelves, you just ask questions in plain English - like "show me monthly revenue from our Shopify store broken down by traffic source." We generate a live, interactive dashboard for you instantly, allowing you to spend time finding insights, not missing data.