Forum Discussion

cutestjigs's avatar
cutestjigs
Frequent Visitor
9 years ago
Solved

Load JSON column Data from MYSQL table to POWER BI

Hi there,   I have table called "accounts".  table has columns like id INT, name VARCHAR, type VARCHAR, date TIMESTAMP, contact JSON. contact has data like {"email": "[email protected]", "phone": "003...
  • cutestjigs's avatar
    cutestjigs
    9 years ago

    Hi v-huizhn-msft

     

    Problem Solved! I downloaded new version of mysql connector and installed it on my computer.  Now it successfully loads table with JSON field. Thanks for your help. 

     

    Best Regards,

     

    Jigu Patel

cutestjigs's avatar
cutestjigs
Frequent Visitor
9 years ago

Hi v-huizhn-msft,

 

I tried to load table without JSON field and it is working fine! Just have problem with JSON field.

 

Thanks,

 

Jigu Patel

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi @cutestjigs,

As I tested, I also can load table wiout json fied successfully, and have a problem with JSON field. And I changed the database driver, there still have the problem. You can load the table without json field, and load a JSON file separatly. 

Best Regards,
Angelia

  • cutestjigs's avatar
    cutestjigs
    Frequent Visitor
    9 years ago

    Hi v-huizhn-msft

     

    Problem Solved! I downloaded new version of mysql connector and installed it on my computer.  Now it successfully loads table with JSON field. Thanks for your help. 

     

    Best Regards,

     

    Jigu Patel