Resolution
Densification is a process of adding rows to underlying data tables for the purpose of filling data gaps between existing values. Densification is exposed in the “Bin” functionality.
In previous versions of Tableau, there was no limit to the number of densification rows. However, Tableau Cloud, and the 2019.4 version (and later) of Tableau Desktop and Tableau Server no longer support unlimited densification row limits. The default max limit is 10,000,000 rows.
See resolutions below for the different Tableau products:
Tableau Cloud
The 10,000,000 row limit for densification cannot be changed. Author the workbook so calculations can be pushed to other resources such as the database, or find other methods of performance improvement. See Create Efficient Calculations and Optimize Workbook Performance for more information.
Tableau Server
In TSM, run the following commands to set the densification row limit to unlimited:
tsm configuration set -k vizqlserver.maximum_densified_rows -v 0
tsm pending-changes apply
Alternatively, you can enter an integer to set a different row-limit. The default is 10000000.
Tableau Desktop on Windows
Open Command Prompt as an Administrator and run the following command to set the densification row limit to unlimited:
tableau.exe -DMaximumDensifiedRows=0
Alternatively, you can enter an integer to set a different row-limit. The default is 10000000.
Tableau Desktop on Mac
Open terminal and run the following command from the /Applications directory to set the densification row limit to unlimited:
open -a Tableau.app –-args -DMaximumDensifiedRows=0
Alternatively, you can enter an integer to set a different row-limit. The default is 10000000.