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.

LeonardZim's avatar
LeonardZim
Regular Visitor
1 year ago

I have a this problem when connecting from Power BI Service via Virtual Machine with Data Gateway to a MySQL Server.


I See the MySQL Data Provider on the as a DB Provider on my Virtual machine.
But still when i try to create the connection: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.

I tried several install and re-install measures of differen versions of the connector.
Also i made sure there is only one connector listed in the machine.config file.

Does anyone have an idea what to do?