Forum Discussion
Power BI cannot connect to MySQL – Requested value 'None' was not found
Hello,
I am trying to connect Power BI to my local MySQL databases (running through XAMPP on port 3306), but I am unable to establish a connection.
Initially, Power BI prompted an encryption warning, and I proceeded with an unencrypted connection. After that, I received the following error:
"Unable to connect – Requested value 'None' was not found."
My setup:
MySQL running locally via XAMPP (port 3306)
Databases visible and accessible in phpMyAdmin (e.g., tracking_db and vehicles_db)
Power BI Desktop
MySQL Connector/NET installed
I also confirmed:
MySQL service is running
Connection works locally through phpMyAdmin
I can access the server using localhost:3306
Propose Solution:
Install MySQL Connector/ODBC 8.0 (64-bit).
Restart MySQL and Power BI.
Connect using localhost:3306.
Choose “Use unencrypted connection” when prompted.
In most cases, this resolves the issue immediately.
If this helps, ✓ Mark as Kudos | Mark as Solution| Help Others
1 Reply
Propose Solution:
Install MySQL Connector/ODBC 8.0 (64-bit).
Restart MySQL and Power BI.
Connect using localhost:3306.
Choose “Use unencrypted connection” when prompted.
In most cases, this resolves the issue immediately.
If this helps, ✓ Mark as Kudos | Mark as Solution| Help Others