You want "join culling" to occur here - Tableau can ignore certain tables you have referenced in the data source under the following conditions:
- The relationships between the tables are defined in the database itself (referential integrity constraints)
- The database schema is a classic "star" - a fact table with single "spokes" as dimensions. Join Culling doesn't work against snowflake or 3NF schemas.
More information here:
If you satisfy these criteria and still see the problem, I'd probably open up a support case.
Thanks Russell !