Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
dor-rog-tech
Helper I
Helper I

ODBC ERROR [22P05]

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.:

dorrogtech_0-1653334508118.png

 

 

I have set up correctly the gateway:

dorrogtech_1-1653334506919.png

 

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 

 

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:

dorrogtech_2-1653334507371.png

 

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!
1 ACCEPTED SOLUTION
v-yetao1-msft
Community Support
Community Support

Hi @dor-rog-tech 

I see that you posted the same post before and it has resolved your issue . 

https://community.powerbi.com/t5/Service/ODBC-ERROR-22P05-Please-help-me/m-p/2533197 

Please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yetao1-msft
Community Support
Community Support

Hi @dor-rog-tech 

I see that you posted the same post before and it has resolved your issue . 

https://community.powerbi.com/t5/Service/ODBC-ERROR-22P05-Please-help-me/m-p/2533197 

Please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors