KNOWLEDGE BASE

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


Published: 18 Feb 2021
Last Modified Date: 08 Jun 2022

Issue

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

Bad value for type double : <number>

Environment

  • Tableau Cloud
  • 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 is a known issue that is resolved in the current version of Tableau Cloud.
Did this article resolve the issue?