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

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

Hi cutestjigs,

When you loaded Mysql table to Power BI, could you please connect Mysql database successfully? Please create a simple table without JSON fields, and check if you can load the table successfully.

Thanks,
Angelia


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
    Microsoft 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