Форум пользователей MySQL

Hi, this is a pretty common issue, so don’t worry.

A few things to check step by step:

Power BI can’t connect to a local MySQL server unless it’s reachable over the network.
If MySQL is installed on your own PC, using localhost or the computer name usually won’t work unless the MySQL service is configured for remote connections.

Check MySQL configuration
In your MySQL config file (my.cnf or my.ini), make sure:

bind-address is set to 0.0.0.0 or your actual IP, not 127.0.0.1

The MySQL service is restarted after changes

User permissions
Ensure the MySQL user you’re using has permission to connect from your machine:

CREATE USER 'user'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON database.* TO 'user'@'%';
FLUSH PRIVILEGES;


Port and firewall

Default MySQL port is 3306. Make sure it’s open in your firewall.

In Power BI, try IP_ADDRESS:3306 as the server name.

MySQL connector
Power BI requires the MySQL Connector/NET to be installed. Make sure you have the latest 64-bit version.

If it still doesn’t work, let us know:

Is MySQL local or on another server?

What exact error message Power BI shows?

That should help narrow it down quickly.