Forum Discussion
Cyrylic display issue
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.
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.
2 Replies
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.TextEncoding.Utf8 was the solution. Thank you very much!
