KNOWLEDGE BASE

Error: "Tableau Data Engine Error 49009: cannot mix aggregate and scalar expressions" When Opening a Workbook


Published: 13 Nov 2017
Last Modified Date: 21 Nov 2017

Issue

When opening workbook in Tableau Desktop using a published data source on Tableau Server 10.4, the following error might occur:
"Tableau Data Engine Error 49009: cannot mix aggregate and scalar expressions" 

Environment

  • Tableau Online
  • Tableau Server 10.4
  • Windows
  • Tableau Data Engine

Resolution

As a Tableau Server Administrator, upgrade to Tableau Server 10.4.1. For more information, see Upgrading Tableau Server in Tableau Help. 

Cause

This behavior is related to a known issue (ID: 700115) which has been fixed in a recent release of Tableau Server. 
Did this article resolve the issue?