Forum Discussion
Postgre ODBC Connection Encoding Error
Dear Team,
I am trying to read data from Postgre through ODBC connection.
Connection was successful but when i am selecting few tables and trying to preview / load, I am getting below error message.
Error Message
DataSource.Error: ODBC: ERROR [22P05] ERROR: character with byte sequence 0xe2 0x80 0x8b in encoding UTF8 has no equivalent in encoding WIN1252
Error while executing the query
My ODBC test connection is successful, I have tried it with both PostgreSQL ANSI(x64) and PostgreSQL Unicode(x64) driver but still am getting same error.
Can someone please help me to solve this issue.
4 Replies
DivakarKrishnan , you have set utf-8 encoding
will check and update -https://community.powerbi.com/t5/Desktop/Making-result-come-in-UTF-8/td-p/873316
Dear Amit,
I have gone through this link but it's not applicable to my scenario.
I am facing issue when trying to preview or load the data after establishing the connection. Also , this one is not happening for all tables but most of the tables.
I have tried it with both PostgreSQL ANSI(x64) and PostgreSQL Unicode(x64).
Please suggest me if there is any other solution for this issue.
Hi DivakarKrishnan ,
Please try these solutions:
1. Install Npgsql-3.2.7. Versions above 4 are incompatible. And uninstall all the other versions, restart server/client.2.Using the postgres ODBC and configuring the connection in unicode mode on System DSN the issue is solved (PBI connection will be ODBC)
You could refer these for help.
https://community.powerbi.com/t5/Desktop/Error-connecting-to-PostGresSQL-db/td-p/439719/page/2
https://community.powerbi.com/t5/Desktop/Change-Encoding-Settings-in-Power-BI/m-p/368131
Did I answer your question ? Please mark my reply as solution. Thank you very much.
Best Regards,
Eyelyn QinDear Anonymous
Which version of Npgsql I have to install ? I am not able to find Npgsql-3.2.7.
Can you please let me know the exact version and link if possible please.
Thanks!
