topic Re: Cannot connect to MySQL database in Power Query

Cannot connect to MySQL database

dibbkd — Wed, 14 Sep 2016 17:52:19 GMT

I have a MySQL database on a Windows 2008 server. How do I get the MySQL data into BI?

From Desktop BI, I click on Get Data > More > MySQL Database > Connect

I then enter my server IP address, 192.168.whatever and my database name

It then just tells me Unable to connect: We encountered an error while trying to connect. Details: ""

(there's nothing but "" after the word details above)

I do already have the mysql-connector-net-6.6.5.msi installed.

Any suggestions?

Re: Cannot connect to MySQL database

arify — Wed, 14 Sep 2016 18:13:31 GMT

Hi,

Can you please send a frown (smiley on top of PBI window) to us, with trace files? It shouldn't have showed an empty message.

(Enable tracing from Options > Diagnostics > Enable Tracing (Verbose) (also you can open the Traces folder from here), then reproduce the failure, then close the PBI Desktop. You can get the traces from Traces folder.)

Thanks

Re: Cannot connect to MySQL database

dibbkd — Wed, 14 Sep 2016 20:11:31 GMT

OK - I just sent a frown with the traces. Actually sent two of them just now.

Re: Cannot connect to MySQL database

arify — Wed, 14 Sep 2016 23:18:42 GMT

Did you send the emails to pbi_fr@microsoft.com ?

Re: Cannot connect to MySQL database

dibbkd — Thu, 15 Sep 2016 01:15:13 GMT

No, you said to send the frown with the files.

I'll see if I can email them now too. I've never seen the pbi_fr@microsoft.com email so had no idea that's what I should have done...

Re: Cannot connect to MySQL database

arify — Thu, 15 Sep 2016 01:17:41 GMT

Sorry, my bad. My coworkers couldn't find your email, can you please look at your sent emails and let me know when & to whom it was sent?

Thanks

Re: Cannot connect to MySQL database

dibbkd — Thu, 15 Sep 2016 01:36:17 GMT

I just now sent them, I hadn't sent them before. That's what I was saying, I had never heard of that email address to send them before.

Edit:

Well, I just got th is auto reply:

The group pbi_fr only accepts messages from people in its organization or on its allowed senders list, and your email address isn't on the list.

Re: Cannot connect to MySQL database

arify — Thu, 15 Sep 2016 01:41:31 GMT

Sorry, it's my bad, it should have been pbidesfb@microsoft.com

Re: Cannot connect to MySQL database

dibbkd — Thu, 15 Sep 2016 01:49:13 GMT

Sent

Re: Cannot connect to MySQL database

arify — Thu, 15 Sep 2016 20:57:33 GMT

Thanks dibbkd! From the traces, it looks like there was a problem with the MySQL driver. Can you please uninstall & reinstall your MySQL ADO.NET driver and see if it fixes the issue?

Thanks

Re: Cannot connect to MySQL database

dibbkd — Thu, 15 Sep 2016 20:58:57 GMT

Can you send me a link so I make sure I install the correct driver?

Re: Cannot connect to MySQL database

arify — Thu, 15 Sep 2016 21:02:16 GMT

This may help: https://go.microsoft.com/fwlink/?LinkId=278885

Re: Cannot connect to MySQL database

dibbkd — Thu, 15 Sep 2016 22:52:26 GMT

OK, that's the link I originally used too.

I uninstalled and reinstalled and get the same results with it not working.

I just sent the frowns with the traces.

Re: Cannot connect to MySQL database

arify — Thu, 15 Sep 2016 23:04:03 GMT

I'm not sure what's wrong with the driver, I think it may be an installation issue. What if you try the newest version? https://dev.mysql.com/downloads/connector/net/6.9.html

Re: Cannot connect to MySQL database

dibbkd — Thu, 15 Sep 2016 23:26:12 GMT

I tried that latest version and no luck

I sent another frown.

Re: Cannot connect to MySQL database

arify — Thu, 15 Sep 2016 23:38:48 GMT

(You don't need to send a frown each time, because it's probably the same issue :) )

I'm not sure what the problem is, all I know is that it's a driver issue (probably an installation issue). We'll look into this issue, thanks for reporting it to us. Meanwhile, you can find a MySQL ODBC driver, and use that with PBI Desktop to connect to your MySQL database.