I am importing data from a MySQL database. I have all of the relevant drivers. When I try to import to powerpivot I get the following errors:
when "select from a list of tables:
"Failed to retrieve data from companies. Reason: ERROR  [MySQL][ODBC 5.1 Driver][mysqld-5.1.58]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[companies].*
FROM [companies]' at line 1"
when i "write a query" that has been validated i receive:
The following system error occurred: Catastrophic failure A connection could not be made to the data source with the DataSourceID of 'dc746dc9-4aaa-4e03-b938-f84a128f5671', Name of 'Custom'. An error occurred while processing the 'Query' table. The operation has been cancelled.
however, i am able to import just fine into excel.
how do i fix the powerpivot import?