title: MySQL ODBC Import Fail
body: <p>I am importing data from MySQL to PowerPivot. I have all of the relevant drivers. When I try to import to PowerPivot I get the following errors:</p>
  
  <p>When I select from a list of tables:</p>
  
  <blockquote>
    <p><code>Failed to retrieve data from companies. Reason: ERROR [42000] [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</code></p>
  </blockquote>
  
  <p><img src="https://i.stack.imgur.com/hfknH.png" alt=""></p>
  
  <p>When I "write a query" that has been validated I receive:</p>
  
  <blockquote>
    <p><code>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.</code></p>
  </blockquote>
  
  <p><img src="https://i.stack.imgur.com/xh3O4.png" alt=""></p>
  
  <p>However, I am able to import just fine into Excel. How do I fix the PowerPivot import?</p>