How Many Rows Can Tableau Handle

How Many Rows Can Tableau Handle

Tableau can handle tens of millions of rows in a single extract and effectively unlimited rows with live connections, but performance depends on your data source, hardware, and extract configuration.

Tableau's Row Limits by Data Source

Tableau Desktop supports up to 1,048,576 rows per extract when using the legacy .tde format. With the modern Hyper extract format (.hyper), that limit is effectively removed, allowing extracts to grow to billions of rows depending on available memory and disk space. Live connections to databases like Snowflake, PostgreSQL, or SQL Server can query billions of rows directly, letting Tableau push filtering and aggregation to the database engine.

Practical Performance Considerations

Even when Tableau can technically load billions of rows, performance degrades as extract size grows. Factors that affect speed include:

• Hardware specs — RAM, CPU cores, and SSD speed
• Extract complexity — calculated fields, blends, and LOD expressions
• Data source type — live versus extract
• Visualization complexity — number of marks and table calculations

Tableau recommends keeping extract sizes manageable and using context filters, extracts, and data source filters to reduce the rows processed per view.

Best Practices for Large Datasets

To handle large datasets efficiently, use extract filters to reduce row counts before loading, aggregate data at the source when detail is not needed, and leverage Tableau's data engine for in-memory processing. For datasets exceeding hundreds of millions of rows, consider aggregating in the database or using Tableau Server's incremental extract refresh to keep extracts lean.

Tableau Desktop vs. Tableau Server Limits