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": "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