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