Unable to connect to mysql database

[Shivipanwar]

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

[v-nuoc-msft · Accepted solution]

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]

It was credentials issue, I have cleared credentials stored in Power BI Desktop and now MySql database is connected.

Thanks @v-nuoc-msft 

[tharunkumarRTK]

@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