Forum Discussion

Faith128's avatar
Faith128
Regular Visitor
6 years ago

MySQL data problem in power bi

I already get MySQL data in power bi desktop. I have some Chinese record in DB like this. How can I decode this on power bi desktop. Thank you.
Need Help
Faith128's avatar
Faith128
Regular Visitor
6 years ago

In power bi, undefined Letters.

JosefPrakljacic's avatar
JosefPrakljacic
Solution Sage
6 years ago

And in your MySQL Table? 

  • Faith128's avatar
    Faith128
    Regular Visitor
    6 years ago

    same undefined Letters in MySQL

    • JosefPrakljacic's avatar
      JosefPrakljacic
      Solution Sage
      6 years ago

      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