topic Re: Cannot Connect Power BI to Local MySQL Workbench Server in Report Server

Cannot Connect Power BI to Local MySQL Workbench Server

jayjay144 — Mon, 10 Mar 2025 21:13:22 GMT

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 credentials I get the error message" 'Internal connection fatal error. Error state: 18'

I have been trying for 2 days to connect. I have tried downloading the .NET connector driver twice, the ODBC connector with a complete install, ensuring I have mysqld.exe installed. I have tried not connecting to root and creating a new user, this still gives me an error message, although different-see attached.

I have watched every single youtube video on this topic and read every blog post, still nothing.

Any help at all? I am at my wits end here.

Re: Cannot Connect Power BI to Local MySQL Workbench Server

lbendlin — Tue, 11 Mar 2025 12:31:19 GMT

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.

Re: Cannot Connect Power BI to Local MySQL Workbench Server

jayjay144 — Wed, 12 Mar 2025 22:20:48 GMT

The solution was using another Net connector version. Connecting to Localhost works however.

Re: Cannot Connect Power BI to Local MySQL Workbench Server

v-veshwara-msft — Wed, 30 Apr 2025 05:24:13 GMT

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.