KNOWLEDGE BASE

"Error while executing the query" Appears When Connecting to Postgresql Version 12


Published: 13 Nov 2019
Last Modified Date: 01 Jun 2020

Issue

The following errors appear when removing a table from the data model canvas followed by adding a new table when connecting Tableau Desktop to Postgresql version 12.
 
"Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database."
 
"Error while executing the query."

"The table xxxxx does not exist."

Error message also captured in the attachment "error.PNG".

Environment

  • Tableau Desktop 2019.3 and 2019.4
  • Windows 10
  • PostgreSQL version 12

Resolution

Uninstall the current Postgresql driver, then install Postgresql ODBC driver version 12. 
  • The installer can be downloaded from this site https://www.postgresql.org/ftp/odbc/versions/msi/

Once the outdated version of Postgresql ODBC driver has been uninstalled, and the current Postgresql ODBC driver version 12 has been installed, Tableau Desktop will utilize Postgresql ODBC 12 to connect to your Postgresql database version 12.

NOTE: Please be aware that Tableau products do not currently fully support PostgreSQL Version 12. 

Cause

Currently Postgresql ODBC driver 9 comes with Tableau Desktop installation. There is an issue of incompatibility between Postgresql ODBC driver version 9 and Postgresql database version 12.
Did this article resolve the issue?