KNOWLEDGE BASE

Error "Densification row limit exceeded." Accessing Workbook on Tableau Online


Published: 14 Jan 2017
Last Modified Date: 07 Nov 2019

Issue

When accessing a published workbook on Tableau Server or Tableau Online, or when attempting to build a workbook in Tableau Desktop, the following error may occur: 
 
TableauException: Densification row limit exceeded. 

Environment

  • Tableau Desktop
  • Tableau Server
  • Tableau Online

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 Online, 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 Online  

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.

Cause

Workbook calculations create load on available memory which cause VizQL process to crash.
Did this article resolve the issue?