Forum Discussion
Internal Error connecting PowerBI to MySQL database
Hello, I am currently trying to connect a dashboard I designed with a MySQL database holding the data currently. However, I keep receiving this error: Details: "An error happened while reading da...
Hi Anonymous ,
In your scenario, are you able to connect to the MySQL database in MySQL workbench? Please ensure that MySQL workbench is installed in the same machine as Power BI Desktop.
If the connection is successful in MySQL workbench, use same connection string and make sure that you use Database credential in Power BI Desktop to connect to the MySQL database, and you can review this blog about connecting to MySQL in Power BI Desktop.
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef