cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
VPerez Visitor
Visitor

Unable to connect to PostgreSQL using ODBC

Hi,

 

I'm trying to setup a datasource for my PostgreSQL database using ODBC. I can't use the PostgreSQL connector because I get certificate errors (the database is in a remote server).

 

I downloaded and installed both 32 and 64 bit versions of the PostgreSQL ODBC driver. I set up a DSN using the ODBC data source tool for PostgreSQL Unicode (x64), which seems to work because I use that DSN on DBeaver and the database loads perfectly.

 

Now I try to use that DSN in Power BI Desktop: Get Data > ODBC > MyDSN. The connection seems to work and I see all the tables from my database, but when I try to load the content of any table in the Navigator panel I get this error:

 

DataSource.Error: ODBC: ERROR [HY000] Error while executing the query
Details:
    DataSourceKind=Odbc
    DataSourcePath=dsn=MyDSN
    OdbcErrors=Table

And no data is loaded.

 

Things I have tried and did not work:

 - Using the UNICODE driver, same problem.

 - Using the 32 bit driver, I get "architecture don't match" error.

 - Using ODBC connection string instead of DSN, same problem.

 

I'm using the latest Power BI Desktop version (2.56.5023.1021 64-bit)

 

Thank you ! Smiley Happy

1 REPLY 1
Community Support Team
Community Support Team

Re: Unable to connect to PostgreSQL using ODBC

HI @VPerez,

 

Current power bi alreated exist built-in PostgreSQL connector, please use specific connector to instead.

 

q6.PNG

 

In addition, you can also try to use UDL to test odbc connection.

Basics first : "UDL Test"

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |