Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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!
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |