Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Unable to find a database provider

I've read up on how to address the "We were unable to find a database provider with the invariant name "MySQL.Data.MySQL Client".   I've downloaded and installed the required MySQL Connector, and sti...
Need Help
rsaharan's avatar
rsaharan
Frequent Visitor
2 years ago

It seems like a common problem. I have the exact issue now. I can connect to MySQL DB from PowerBI Desktop on my local system. But as soon as I published the report and tried to refresh the data, it failed with the same error. Unable to find the solution yet. This is painful as reports do not get updated data and fail to make decisions. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I have the exact same problem. I cant find a solution on the internet anywhere. I think it is because the published version uses the 8.3.0 version of the connector. That version failed on my system so i used a a older version which worked. But when i publish the dashboard it cannot refresh 😞 Please contact me when you find a solution rsaharan.

    • myusrn's avatar
      myusrn
      Regular Visitor
      2 years ago

      See reply above. You need to apply the same version of connector that works on your desktop to your enterprise data gateway as well if you want published report(s) mysql data refreshes to work as well.

      • rsaharan's avatar
        rsaharan
        Frequent Visitor
        2 years ago

        Yes, Thats correct.