Issue
When accessing a published workbook on Tableau Server or Tableau Cloud, or when attempting to build a workbook in Tableau Desktop, the following error may occur:TableauException: Densification row limit exceeded.
Last Modified Date: 08 Jun 2022
Environment
- Tableau Desktop
- Tableau Server
- Tableau Cloud
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
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
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
Cause
Workbook calculations create load on available memory which cause VizQL process to crash.Additional Information
Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials