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

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


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>


  • Tableau Cloud
  • PostgreSQL


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
  • 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.


This is a known issue that is resolved in the current version of Tableau Cloud.
Did this article resolve the issue?