KNOWLEDGE BASE

Error "Database error 0x80040E14


Published: 14 Mar 2013
Last Modified Date: 16 Aug 2016

Issue

When creating a calculated field, one of the following errors might occur:

Database error 0x80040E14: Case expresssions may only be nested to level 10
Database error 0x80040E14: Missing ), ], or Item in query expression

Environment

  • Tableau Desktop
  • Microsoft SQL Server or Access database

Resolution

Option 1

Rewrite case statement without nesting.

Option 2

Use an extract instead of a live connection to data source.
 

Cause

Database limitation of Microsoft SQL Server.

Additional Information

May also be a limitation of other Microsoft Data Sources.
Did this article resolve the issue?