title: How do I use MySQL as data source in Microsoft SQL Server Analysis Services?
body: <p>I have installed the <a href="http://www.mysql.com/downloads/connector/net/" rel="nofollow noreferrer">latest .net connector</a>, I can add MySQL databases as Data Sources, I can even browse through the data from Business Intelligence Studio.</p>
  
  <p>The problem is that I <strong>cannot</strong> create a datasource view, or if I do create one without tables, trying to add them after the fact gives me the same error.</p>
  
  <p>Specifically it looks like the data source view wizard tries to submit queries against the MySQL database using square brackets/braces, and the query bombs.</p>
  
  <p>I get an error message like:</p>
  
  <pre><code>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 '[my_db].[cheatType]' at line 2
  </code></pre>
  
  <p>How can this be done?</p>