Need help with connecting to a MySQL server

[execman]

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 Cpanel via the Remote MySQL panel. 

Server: I tried using the IP address of the server, my website's url, with and without "www"

Database: I entered the database name

Credentials: 

Windows: Not Selected

Database: Selected

Username:

Password: 

For the username and password, I tried the MySQL database password and the cpanel password. 

Please assist if you can. Thanks in advance. 

[Alice]

Hi! I have the same error when i'm trying to connet to the remote server with mySQL database. I've tried different variations of server name, but it doesn't work. Does anybody know how the string with server name should look like? 

[Greg_Deckler]

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:

http://social.technet.microsoft.com/wiki/contents/articles/32004.power-bi-tips-for-working-with-mysq...

[lakshnajha]

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]

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]

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]

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.

[Greg_Deckler]

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?

[lakshnajha]

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.

[Greg_Deckler]

@lakshnajha - Here is what I would do, first, download and install MySQL server and tools on the desktop you are using Power BI Desktop on.

http://dev.mysql.com/downloads/mysql/

Make sure you can connect to your local MySQL server. Then, try to connect to AWS MySQL server. Let me know if that works.

[AbdulMukhtar]

My case is:

• server is on Azure, MySQL Database. 
• I need to pull the data into PowerBI service every hour

By following below link on community.power Bi site. I have concluded following approach.

http://community.powerbi.com/t5/Service/connect-mysql-to-web-version-of-Power-Bi/td-p/2668 

    i) Connect to My sql Database using Power BI Desktop 

   ii) Deploy Power BI desktop to power BI service

  iii) Schedule data referesh using Personal gateway.

I would like your comment on whether the above approach is correct or not and in case it is correct where do i need to install "Personal gateway" on Azure server (Since database is on cloud) or my personal desktop or any machine?

[dlash]

So does powerBI support connecting to a database server running on a remote machine? 

It appear the diaload does not even support a mysql port number. 

So does it NOT work? 

[lakshnajha]

on my windows machine works. thanks so much

[lakshnajha]

hi 

is it possible to use power BI on mac machine. My primary machine is mac so i will love to use power BI on that

[execman]

I am trying to connect it via Power BI Desktop directly. So it would be from Get Data - More - Database - MySQL Database.