Unable to import data from MySQL

[Yingsha]

Hi Everyone,

I'm facing issue while loading data from MySQL server.

When I import table 'MEMBERS' ( 900,652 rows), succeed;

When I import table 'SALES' ( 8,396,737 rows), I FAILED.

It says:

"Timeout expired. the timeout period elapsed prior to completion of the operation or the server is not responding"

But my colleague can successfully import 'SALES' . (The same table, but use her laptop)

I suspect there is something wrong with my computer, but I don't know how to find out ...

Any ideas on this? 

Thanks !

Yingsha

[v-yingjl]

You can try to check whether you can access the table in MySQL database first in your device.

If it can shown successfully in MySQL, you can try to clear the credentials of MySQL in Power BI Desktop of your device, open a new blank report to connect to the same table to check it again.

Best Regards,
Community Support Team _ Yingjie Li

[Yingsha]

Hi Yingjie,

Thanks for your help.

I can access the table in MySQL database

I clear the credentials of MySQL in Power BI Desktop of my device, open a new blank report to connect to the same table, but STILL FAILED.

It says:

skpdata MEMBER_SPENDING_DETAILS

无法将修改保存到服务器。返回的错误:“OLE DB 或 ODBC 错误 : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.。 ”。 @v-yingjl