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

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.