topic Re: Postgre ODBC Connection Encoding Error in Desktop

Postgre ODBC Connection Encoding Error

DivakarKrishnan — Mon, 30 Nov 2020 11:28:13 GMT

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.

Re: Postgre ODBC Connection Encoding Error

amitchandak — Mon, 30 Nov 2020 11:39:32 GMT

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

Re: Postgre ODBC Connection Encoding Error

DivakarKrishnan — Mon, 30 Nov 2020 11:51:51 GMT

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.

Re: Postgre ODBC Connection Encoding Error

Anonymous — Wed, 02 Dec 2020 06:04:30 GMT

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 Qin

Re: Postgre ODBC Connection Encoding Error

DivakarKrishnan — Wed, 02 Dec 2020 07:06:56 GMT

Dear 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!