Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Unable to Connect to MySQL Database

Upon the recent update, I have been unable to connect to our MySQL data sources.  I have been receiving the following error message: "An error happened while reading data from the provider: 'Object r...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

     

    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.

    Thanks,
    Lydia Zhang

eparedez's avatar
eparedez
New Member
9 years ago

Using a power bi desktop or service?

Do the following:

- Check the properties connection..
- Check if the MySQL port is open

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I am using Power BI Desktop.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

     

    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.

    Thanks,
    Lydia Zhang

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      After clearing the previous permission and reconnecting to the database everything is working smoothly. 

       

      Thank you for the solution!