Forum Discussion
Need help with connecting to a MySQL server
Are you trying to connect from the service or from Power BI Desktop or from Excel?
I have an article on TechNet that gives some notes around this:
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
Generally when I have gotten this to work, I have had MySQL installed directly on the boxt that I am using Desktop on. Can you provide any details about your configuration?
Hi
Thanks for your response.
I have a deskptop power BI and using AWS database to connect to.Please let me know what other info you need from me.
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
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!
I am trying to connect it via Power BI Desktop directly. So it would be from Get Data - More - Database - MySQL Database.
