Cyrylic display issue

[Revenant]

Hello, folks!

I faced an issue while importing data from MySQL source - header row isn't displayed correct though the rest of the data is OK.

I did not Use First Row as a Header - column names were imported directly from MySQL header. The encoding is used in MySQL is utf8_general_ci

I didn't find any ways to change the encoding of the header while importing.

[Anonymous · Accepted solution]

Hi @Revenant ,

You may try to convert it in your MySQL Table. Hope these links could help:

How to convert a MySQL database to UTF-8

MySQL: Converting an incorrect latin1 column to utf8 | NicJ.net

Mysql: Convert encoding to UTF8 without garbled data (Example)

Or try functions to specifies the text encoding type.

TextEncoding.Type - PowerQuery M | Microsoft Docs

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

[Revenant]

TextEncoding.Utf8 was the solution. Thank you very much!