KNOWLEDGE BASE

Logical Query Tree Has [X] Joins In Some Branch, Maximum Number Allowed Is 75


Published: 20 Dec 2019
Last Modified Date: 02 Jun 2020

Issue

When running the flow in Tableau Prep Builder the following error might occur:
Unable to process an output: Logical Query Tree has [x] joins. Failure evaluating to database: Logical Query tree has [x] joins in some branch, maximum number allowed is 75. DataServiceFailure Try running the flow again or review the log file for more details" is received.

The same error might occur on browsing a view on Tableau Server with published data source that consists of many joined tables.
 

Environment

  • Tableau Prep Builder 2019.4.2
  • Windows 10
  • Tableau Data Engine
  • Tableau Server 2019.4

Resolution

As a possible workaround, pre-join the tables in the database first and then connect to it.
 

Cause

Tableau Prep Builder limits the number of joins possible to maximum 75 because a greater number of joins will cause the product to quit unexpectedly. The limit is by design.
 
Did this article resolve the issue?