Forum Discussion
Cannot Connect Power BI to Local MySQL Workbench Server
Hi, I am trying to import SQL server data into Power BI. I am using a local instance of MySQL Workbench to do so. I am able to put in the server and database just fine, but when I input my creden...
1. do not use "localhost". Use a fully qualified domain name (FQDN). You will need a gateway, and that gateway has no idea what "localhost" means
2. uninstall your current Net connector and install version 8.0.28 - it is one of the few versions known to actually work.
The solution was using another Net connector version. Connecting to Localhost works however.
Hi jayjay144 ,
Thanks for engaging with Microsoft Fabric Community,
Also thanks for confirming that using another .NET connector version resolved your issue.
Would you mind marking the helpful reply as "Accepted Solution" to help others facing similar issue find the solution quickly.
Thanks lbendlin for your valuable contribution to the community.
