Error "Logical Query tree has [x] nodes, maximum number allowed is 500000" when Using Calculations

Published: 12 Aug 2019
Last Modified Date: 12 Aug 2019


When creating views in Tableau Desktop using calculations, sometimes the following error will occur:

Logical Query tree has [x] nodes, maximum number allowed is 500000. For extract data sources, try optimizing the extract and republishing:

Unable to properly calculate the domain for the field '[field name]'. Displayed data may be incorrect.


  • Tableau Desktop
  • Text Files


The query created by the calculation is too complex.

Additional Information

A long IF THEN calculation can be converted to a Tableau group automatically by duplicating the data source, setting up a blend, and following Bring a Field into the Primary Data Source.
Did this article resolve the issue?