KNOWLEDGE BASE

Error "Resources exceeded during query execution: Not enough resources for query planning - too many subqueries or query is too complex" when loading a view


Published: 17 Jan 2022
Last Modified Date: 18 Jan 2022

Issue

When loading a dashboard, an error occurs

"Resources exceeded during query execution: Not enough resources for query planning - too many subqueries or query is too complex."

Environment

  • Tableau Desktop 2021.1.5 or lower, 2020.4.8 or lower
  • Tableau Server 2021.1.5 or lower, 2020.4.8 or lower

Resolution

Upgrade to version 2021.1.6, 2020.4.9 or higher version.

Cause

This is a known issue that is fixed in more recent versions of Tableau Server and Tableau Desktop.
The issue is related to worksheets containing multiple filters and the data sources with Relationships and multiple logical tables.
Did this article resolve the issue?