Postgre ODBC Connection Encoding Error

[DivakarKrishnan]

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.
 

[v-eqin-msft]

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

[DivakarKrishnan]

Dear @v-eqin-msft 

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!

[amitchandak]

@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

[DivakarKrishnan]

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.