Forum Discussion
Unable to connect to PostgreSQL database on 64 bit windows machine using ODBC connection
Error message: DataSource.Error: ODBC: ERROR [HY000] Error while executing the query
Details:
DataSourceKind=Odbc
DataSourcePath=database=Travel_Information;driver={PostgreSQL Unicode(x64)};port=5432;server=travel-information.chda0n3dhd8k.eu-west-1.rds.amazonaws.com
OdbcErrors=Table
Connection string I am using: database=Travel_Information;driver={PostgreSQL Unicode(x64)};port=5432;server=travel-information.chda0n3dhd8k.eu-west-1.rds.amazonaws.com
Any suggestions?
8 Replies
Hi georgehalford22,
In Power BI desktop, there is a built-in PostgreSQL data source for us to get data, please try this instead.
By the way, is there any specific reason you need to use ODBC connect to PostgreSQL?
Best Regards,
Qiuyun YuFor both ODBC and through the normal connector on Power Bi I am unable to connect, the error messages are extremely vague.
Hi georgehalford22,
Would you please share the error message when you get data from PostgreSQL in Power BI desktop?
Also please enable the desktop trace log and share the log files with us. You can upload log files to your OneDrive or Dropbox then share the link here.
Best Regards,
Qiuyun Yu
Same error here.
And when I try to connect directly via "Get Data>Database>PostgreSQL database connection", I get this error.
Does anybody have an update about this ODBC issue?
Was this issue ever resolved? I'm attempting to connect via ODBC and as above, I can see the tables, but if I then preview the data I get the error
DataSource.Error: ODBC: ERROR [HY000] Error while executing the query
Details:
DataSourceKind=Odbc
DataSourcePath=database=**;driver={PostgreSQL ANSI(x64)};port=****;server=***.***.***.***
OdbcErrors=Tableand the data doesn't load.
Replacing the 32-bit version of Microsoft 365 by the 64-bit version solved that issue.
