cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Faith128
Regular Visitor

MySQL data problem in power bi

I already get MySQL data in power bi desktop.

I have some Chinese record in DB like this.

Annotation 2019-10-30 142018.png

How can I decode this on power bi desktop.

Thank you.

7 REPLIES 7
JosefPrakljacic
Solution Sage
Solution Sage

Hey @Faith128,

 

you can't decode it since its already wrong in your database. Your table in MySql already have to show the "decoded" format. 

You have to set the caracter set and collation of the table within MySQL BEFORE you insert any chinese characters.

 



 

mysql> create table foo (v varchar(10)) CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into foo values('太原星河湾酒店'); Query OK, 1 row affected (0.00 sec)

mysql> select * from foo;
+-----------------------+
| v |
+-----------------------+
| 太原星河湾酒店 |
+-----------------------+
1 row in set (0.00 sec)

 

 

 

If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

Have a nice day!

BR,
Josef
Graz - Austria

 

 

Hi JosefPrakljacic, Thanks for your reply. My DB setting is already utf8_unicode_ci. But still get this. So I want to decode it on power bi desktop. Is it impossible?

When you query your MySQL Table what result do you get?

 

Chinese Letter or some undefined Letters?

In power bi, undefined Letters.

And in your MySQL Table? 

same undefined Letters in MySQL

Then @Faith128 I'm sorry you are not able to "decode" it in PowerBI. You should try to convert it in your MySQL Table.

I'm not a MySQL Expert but maybe this will help (you need to scroll a bit down) or this (i think this link is better)

 

If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

Have a nice day!

BR,
Josef
Graz - Austria

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors