title: Microsoft Power BI connect to mysql
body: <p>My mysql server is on the cloud. I install the connector to connect mysql on <strong>Window 7</strong> machine. Then I try to connect from Power BI to MySQL server. I give the IP address and database name, my root credential. Then I click on save. It gives me the following error.</p>
  
  <blockquote>
  <pre><code>DataSource.Error: MySQL: Unable to connect to any of the specified MySQL hosts.
  Details:
      Message=Unable to connect to any of the specified MySQL hosts.
      ErrorCode=-2147467259
  </code></pre>
  </blockquote>
  
  <p>Then I try to connect from mysql workbench with the same credential from the same machine. I can connect, but I am not connecting from Excel Power BI.</p>