Unable to Use Aggregations with Published ODBC Data Sources

Published: 10 Jul 2014
Last Modified Date: 11 Jan 2017


When you use web authoring on a workbook connected to a published data source with ODBC connections, one of the following errors might occur:

The aggregate used for '<Name of Measure>' is not supported by the data source.


DataSourceException: Invalid field formula due to limitations in the data source.


  • Tableau Server
  • Generic ODBC Connection
  • Published data sources


Option 1

Upgrade to Tableau Server 9.2 or later version. For more information, see Upgrading Tableau Server.

Option 2

Use one of the following workarounds:
  • Use a live connection to the database rather than connecting to a published data source.
  • Use a non-ODBC connection.


This behavior is related to Known Issue 439898 that has been corrected in more recent releases.
Did this article resolve the issue?