Forum Discussion

Frequent Visitor

2 years ago

Solved

Unable to connect to mysql database

Hi all, recently, I found that I'm unable to connect Mysql database into Power bi desktop encountered below error:

Unable to connect

We encountered an error while trying to connect.

Details: "An error happened while reading data from the provider: 'One or more errors occurred.'

Please help me to how can be fix this error.

I am using Mysql version - C++ 8.0.28

tharunkumarRTK
Super User
2 years ago
Shivipanwar

Have you installed Oracle MySQL dot net connector in your machine? if not then follow the instructions in this page.
https://learn.microsoft.com/en-us/power-query/connectors/mysql-database

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun
Anonymous
Not applicable
2 years ago
Hi Shivipanwar

tharunkumarRTK Thank you very much for your prompt reply.

The missing installer is indeed a possible reason.

Allow me to add something here:

In Power BI Desktop, go to and enable tracking. Try connecting to MySQL and check the detailed logs in the traces folder for more specific error messages.

Try clearing any credentials stored in Power BI Desktop and then reconnect.

If your connection requires encryption, make sure it is set up correctly.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Shivipanwar
  Frequent Visitor
  2 years ago
  It was credentials issue, I have cleared credentials stored in Power BI Desktop and now MySql database is connected.
  Thanks Anonymous
Pbidev342
Helper I
2 years ago
Check out this video guide on correct drivers
https://youtu.be/EL3DdMVAUnQ?si=ie7O3RiB0nrIap0B