Forum Discussion

execman's avatar
execman
New Member
10 years ago

Need help with connecting to a MySQL server

Hi,    I am a new Power BI user and is trying to connect to a MySQL database. I tried many different setting but I am unable to get it to work.    Setup: I added my computer's IP address in Cpane...
Need Help
lakshnajha's avatar
lakshnajha
New Member
10 years ago

Hi

I am getting error. I downloaded the version from microsoft link 

http://dev.mysql.com/downloads/file/?id=412152

but still getting it

Pls help

We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.
This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'MySQL Connector/Net': https://go.microsoft.com/fwlink/?LinkId=278885"

 

tx

tolisg's avatar
tolisg
New Member
10 years ago

Hello,

 

I'm getting the very same error. I try to connect MySQL server running on my laptop with Power BI Desktop edition also on my laptop. Of course I have already installed the 64bit MySQL connector. My OS is Windows 7. 

Any help is more than welcome.

 

Many thanks

  • tolisg's avatar
    tolisg
    New Member
    10 years ago

    I found the solution on my own. I used 127.0.0.1:3306 in Power BI as Server declaration instead of "localhost" and it worked!

    • supriya_13's avatar
      supriya_13
      Helper I
      5 years ago

      Hi , 
      what you specified in username and password.
      because if I put username = root and leaves the password blank , it still gives me that can't connect.