Forum Discussion

MarkJEverest's avatar
MarkJEverest
New Member
4 years ago
Solved

Power BI Report Server cannot connect to MySQL despite the client drivers being installed

Hi,   We have PowerBI Server installed on two boxes - one for test and one for production. On both we have installed the .NET MySQL connector 8.0.28 and rebooted the servers. When looking in ODBC...
Mysql
Power BI Report Server
  • d_gosbell's avatar
    d_gosbell
    4 years ago
    MarkJEverest wrote:

    When looking in ODBC (64-bit) in control panel the latest MySQL drivers are showing as installed, so I know the installation has gone fine.

     

    The ODBC drivers are registered differently to the .net drivers so you cannot assume that the .net drivers are OK just because the ODBC ones appear to be there.

     

    MarkJEverest wrote:

    However, when I try and do the same thing on the production server I get the following error after clicking the "Test connection" button:

    MySQL: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.

    I would suggest trying to uninstall and the re-install checking the options that are chosen as this suggests that there is an issue registration of the .net drivers.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi MarkJEverest ,

 

Whether the advice given by d_gosbell  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry