Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |