KNOWLEDGE BASE

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


Published: 13 Nov 2019
Last Modified Date: 10 Feb 2021

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

Option 1

Upgrade to Tableau Desktop 2020.4 to connect to PostgreSQL 12 using a JDBC driver that is installed with the product.


Option 2

If you cannot upgrade to Tableau Desktop 2020.4, you can try the steps below:
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.

 

Cause

There is an incompatibility between the PostgreSQL ODBC 9.x driver, that comes with Tableau Desktop versions prior to 2020.4, and PostgreSQL 12 databases.
Did this article resolve the issue?