Forum Discussion

jayjay144's avatar
jayjay144
Frequent Visitor
1 year ago

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 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. Connecting using rootError connecting with a new userError connecting using root

Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    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.

    • jayjay144's avatar
      jayjay144
      Frequent Visitor
      1 year ago

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

      • v-veshwara-msft's avatar
        v-veshwara-msft
        Community Support
        1 year ago

        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.