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

Win a FREE 3 Day Ticket to FabCon Vienna. Apply now

Reply
Anonymous
Not applicable

unable to connect MySQL database

Hello Guys,
I tried to connect Mysql database to power bi it show me the error like,we encountered an error while trying to connect, Detalis:"Mysql;Unable to connnect to any of the specified MySQL hosts,"

Mysql Error.PNG 
please help,
thanks,
pra137

5 REPLIES 5
v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

 

Has your problem been solved?

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Yes

 

v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

 

v-lionel-msft_0-1612508371183.png

1. Please check whether the server name and database name you entered are correct. If the server name is wrong, Power BI will report this error.

 

2. What's your Power BI Desktop version and Mysql version? 

Please update Power BI to the latest version.

 

3. Check whether the firewall restricts local access to the IP address where the database is located.

 

4. Check whether the status of the database service is "running".

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Anonymous , Install latest version .net connector and check

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

 

Also my sure you IP is having access of MySQL server

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
timg
Solution Sage
Solution Sage

Hi Pra,

I see there was an older topic with the same question, could you check if the solutions proposed there solve the issue for you? Unable to connect MYSQL | Details: "MySQL: Unable ... - Microsoft Power BI Community

regards,

Tim





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.