Forum Discussion
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...
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
Microsoft Employee
Microsoft EmployeeHi @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
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