Reply
soldier_rong
Helper II
Helper II
Partially syndicated - Outbound

Connecting to Oracle database with Chinese garbled code

Dear~~

The Chinese of the data we check in PLSQL is normal, but the Chinese on Power Query is garbled. Thanks for any ideas.

PLSQL:

soldier_rong_0-1669284410443.png

 

Power Query:

soldier_rong_1-1669284469696.png

 

1 ACCEPTED SOLUTION

Syndicated - Outbound

Hi @soldier_rong 

 

Sorry for the delay. Please try this again. 

Text.FromBinary(Text.ToBinary([Column Name], TextEncoding.Ascii), TextEncoding.Utf8)

 

Best regards,

Jing

View solution in original post

10 REPLIES 10
v-jingzhang
Community Support
Community Support

Syndicated - Outbound

Hi @soldier_rong 

 

Try adding a custom column with the following code. Change [Column Name] accordingly. This will convert a text column from Windows encoding to UTF8. Chinese characters usually require encoding UTF8. 

Text.FromBinary(Text.ToBinary([Column Name], TextEncoding.Windows), TextEncoding.Utf8)

vjingzhang_0-1669354891409.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Syndicated - Outbound

Hi @v-jingzhang ,

 

Hope you well.

 

Any idea would be appreciated~~

Syndicated - Outbound

Hi @soldier_rong 

 

I learnt from another thread of yours that your Oracle DB is using WE8ISO8859P1. WE8ISO8859P1 is ISO8859 Part 1, it is a Western European character set, based on the ISO standard; it is also known as Latin-1. Choosing a Character Set (oracle.com)

 

Perhaps you can use SQL statements to query data from the Oracle database and convert the column from ISO-8859-1 to Utf-8. There are some relevant solutions in the following link, but it doesn't have an example for Oracle, hope it would be helpful: Convert Text Value in SQL Server from Utf8 to Iso 8859-1 - ITCodar

 

Best regards,

Jing

Syndicated - Outbound

Hi @v-jingzhang ,

still not worked....Any idea would be appreciated.

Syndicated - Outbound

Hi @soldier_rong 

 

Sorry I don't have other ideas sadly. Do you have a Power BI Pro license? If you have, you can create a support ticket at Support | Microsoft Power BI without additional charge. Escalation engineers will contact you soon and they can support you in some other ways. How to create a support ticket in Power BI

vjingzhang_0-1673419412563.png

 

Best regards,

Jing

Syndicated - Outbound

Hi @v-jingzhang ,

 

Noted with thanks. We have the Pro license but not under my account. so can I create a support ticket like this myself? Or do I have to ask the Pro user to make a case like this?

 

Thanks again.

Syndicated - Outbound

Hi @soldier_rong 

 

You need to ask the Pro user to help create the support ticket.

 

Jing

Syndicated - Outbound

Hi @soldier_rong 

 

Sorry for the delay. Please try this again. 

Text.FromBinary(Text.ToBinary([Column Name], TextEncoding.Ascii), TextEncoding.Utf8)

 

Best regards,

Jing

Syndicated - Outbound

Hi @v-jingzhang ,

 

Thanks again. I tried it, but still not worked.....

I'm not sure if I want to go up to the database level to modify this code set WE8ISO8859P1, but this has a big impact on our production. So any suggestions or ways to fix the messy codes?

 

Thanks in advance.

 

BR,

Soldier

Syndicated - Outbound

Hi @v-jingzhang 

Hope you are well.

 

I try but not worked and still garbled code(please see the pic 1).

I also try below code and the result is not good as pic 2..

 

soldier_rong_1-1669356501532.png

soldier_rong_0-1669356453764.png

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)