KNOWLEDGE BASE

Unable to Use Aggregations with Published ODBC Data Sources


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

Issue

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.

Or:

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

Environment

  • Tableau Server
  • Generic ODBC Connection
  • Published data sources

Resolution

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.

Cause

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