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

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


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>


  • Tableau Online
  • 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 behavior is related to a known issue with ID 1231448 which is currently under investigation.
Did this article resolve the issue?