Forum Discussion

DivakarKrishnan's avatar
DivakarKrishnan
Helper II
5 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
DivakarKrishnan
Helper II
5 years ago

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!