Forum Discussion
MarioVW
6 years agoAdvocate I
Unable to connect to MySQL (Cannot load from mysql.proc)
Hello everyone, I'm trying to connect to MySQL from PowerBI Desktop (Version: 2.73.5586.802 (september 2019). I already installed MySQL Connector/Net 8.0.16 and entered all the relevant settings (se...
amitchandak
6 years agoSuper User
Please check these two
https://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-MySQL-database/td-p/746202
https://community.powerbi.com/t5/Desktop/MySQL-Connection-Error/td-p/317748
- MarioVW6 years agoAdvocate IThanks for the suggestion.
I had already read the first thread because I had the same issue before, I already have MySQL Connector/Net 8.0.16 as they suggested in the thread. However, people talk about the x64 version of th connector which apparently doesn't exist. I searched everywhere in MySQL's site but only the x86 version is available. Doing further research I found that the x86 version is targeted for Any CPU so it should work in x64 without problem (I'm running Power BI x64).
As for the second thread, the server I'm connecting to does not have SSL or any type of secure connection, nor do I have access to making any configuration changes on the server. However, as I pointed out, I can conn without problem using MySQL Workbench and ODBC driver.- v-lid-msft6 years agoCommunity Support
Hi MarioVW ,
For the issue, I cannot reproduce it here. We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- MarioVW6 years agoAdvocate I
Unfortunately I'm not (yet) a Pro user, so I can't open a support ticket.
But thanks for the suggestion, I'll try that out once I become Pro.