Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
cutestjigs
Frequent Visitor

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

1 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

View solution in original post

4 REPLIES 4
v-huizhn-msft
Microsoft Employee
Microsoft Employee

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


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

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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors