Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Unable to connect to MySQL server (Docker)

I have set up a Docker container with a MySQL server running version 8.0.21 (also tried 8.0)

 

Whenever I try to connect to the database in Power BI Desktop I get the following error:

tol_0-1602800526816.png

We encountered an error while trying to connect.

Details: "An error happened while reading data from the provider: 'Internal connection fatal error. Error state: 18'"

 

I also get this error while trying to connect to a MySQL server in Powe BI Desktop running on a Xampp installation.

 

I have tried to uncheck "Encrypt connections" in Data source settings. 

 

I can connect to the server via MySQL Workbench without any problems and I can also login via PhpMyAdmin running on the same instances. 

 

I have checked that my credentials and that I am using the correct ports etc.

 

I am running the latest version of Power BI Desktop.

 

Any clues?

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

All along the solution was simple: get data from a MySQL Database instead of a SQL Server database 😅

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

All along the solution was simple: get data from a MySQL Database instead of a SQL Server database 😅

amitchandak
Super User
Super User

@Anonymous , is latest .net driver is installed

https://dev.mysql.com/downloads/connector/net/

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Server version: 8.0.21 - MySQL Community Server - GPL

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.