KNOWLEDGE BASE

Error "Bad value for type double" Opening Workbook or Refreshing Extract in Tableau Online


Published: 18 Feb 2021
Last Modified Date: 18 Feb 2021

Issue

When opening a workbook connected to PostgreSQL, or when refreshing a PostgreSQL extract in Tableau Online, an error occurs:

Bad value for type double : <number>

Environment

  • Tableau Online
  • PostgreSQL

Resolution

As a workaround, choose one of the following options:
  • Use a Custom SQL query to cast any "money" columns as another type, such as "numeric" or "decimal". For instructions, see Create Cast at Postgresql.org.
  • Change the column type in the PostgreSQL database from money to numeric or decimal.
Disclaimer: Although we make every effort to ensure links to external websites are accurate, up to date, and relevant, Tableau cannot take responsibility for the accuracy or freshness of pages maintained by external providers. Contact the external site for answers to questions regarding its content.

Cause

This behavior is related to a known issue with ID 1231448 which is currently under investigation.
Did this article resolve the issue?