Load JSON column Data from MYSQL table to POWER BI

[cutestjigs]

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": "info@xxx.com", "phone": "0038828288", "mobile": "04838888", "address": "xxxx, xxx, xxx", "country": "xxxx"}

I want to load this table into power bi. It showing me error 

DataSource.Error: MYSQL:Fatal error encountered during command execution

Errorcode = -2147467259

I want to use all this details in my report. How can I make columns for all json fields?

I want table which will look like id INT, name VARCHAR, type VARCHAR, date TIMESTAMP, email VARCHAR, address VARCHAR, phone VARCHAR, mobile VARCHAR.

Please help me in this.

Thank you

[v-huizhn-msft]

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]

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]

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 · Accepted solution]

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