Import data into Microsoft Powerpivot from MySQL database

See more:

MySQL

MS-Excel

ODBC

Hello,

I'm trying to import data into Microsoft PowerPivot from MySQL database. I have created a connection by using OLE DB provider. I've tested the connection, and it succeeded. However when I import the tables from the database, it gives an error below:

The following system error occurred: Catastrophic failure
A connection could not be made to the data source with the DataSourceID

I've already search for the solution. Someone says that instead of choosing the tables one by one, you need to write a SQL query for importing the data. I've tried it, but it also did not work.

Does anyone have an idea to solve this problem?

Kind regards.