ODBC ERROR [22P05] - Please help me.

[dor-rog-tech]

Hello!

I have problem, with my ODBC driver (I think so.)

I have setup correctly my odbc driver in order to work with my postgres db.:

I have set up correctly the gateway:

And it is co-responding to the powerBI desktop.

Now, when I want refresh the data, I get this error massage:

Underlying error code: -2147467259
Underlying error message: ODBC: ERROR [22P05] ERROR: character with byte sequence 0xd7 0xa4 in encoding "UTF8" has no equivalent in encoding "WIN1252";
Error while executing the query
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: Odbc
Microsoft.Data.Mashup.ValueError.DataSourcePath: database=......;driver={PostgreSQL ANSI};dsn=PostgreSQL30;port=5432;server=......
Microsoft.Data.Mashup.ValueError.OdbcErrors: #table({"SQLState", "NativeError", "Message"}, {})
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net
Activity ID: c25ed472-2f9f-43b7-adb0-c319e0b476d8
Request ID: 6eef4633-671a-1b05-7a21-b80a15ee8c3d
Time: 2022-05-23 10:56:56Z

I have read all of the community posts regarding this problem, but I did not succeed to solved it.

I tried to setup new driver for unicode:

And save the powerbi profect with this datasource:

database=....;driver={PostgreSQL Unicode};dsn=PostgreSQL30;port=5432;server=......

But when I tried to open new gateway to this path, it gives me this error:

Unable to create data source. Unable to connect to the data source.

Details: Dor-ROF: ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I really need this dataset to be able to re-fresh.

Thanks!

[v-xiaotang · Accepted solution]

Hi @dor-rog-tech 

Try to hit on the "Manage DSN" Button and changing the driver from "PostgreSQL ANSI(x64)" to "PostgreSQL Unicode(x64)", then restart and check if it works ok.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[dor-rog-tech]

Thanks @v-xiaotang !