KNOWLEDGE BASE

Error When Pivoting in Tableau Prep Builder: Query Text Limit of 67108864 Bytes Exceeded


Published: 16 Jul 2019
Last Modified Date: 31 Jul 2019

Issue

When pivoting large numbers of columns in Tableau Prep Builder, an error may occur: Query text limit of 67108864 bytes exceeded.

Environment

  • Tableau Prep Builder 2019.2.2
  • Windows 10
  • Excel

Resolution

Upgrade to Tableau Prep Builder version 2019.2.3 or later versions.

Cause

This behavior is a known issue, ID 942953, that has been resolved in more recent versions of Tableau Prep Builder.
Did this article resolve the issue?