Forum Discussion

LeonardZim's avatar
LeonardZim
Regular Visitor
1 year ago

Connect to MySQL Database via Virtual Machine Data Gateway from Power BI Service

I have the following problem:   When i want to connect to the MYSQL-Database (when creating a new dataflow) i get the following error: We were unable to find a database provider with invariant nam...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi LeonardZim ,

 

You can try reinstalling the driver and restarting the gateway and make sure workbench and connector are the same version.

There is another way to downgrade the Connector:Solved: Power BI Desktop - Unable to Connect - Microsoft Fabric Community

Also try deleting all lines of the configuration file in the following image:

Solved: Power BI Report Server cannot connect to MySQL des... - Microsoft Fabric Community

 

Best Regards,
Zhu

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

  • LeonardZim's avatar
    LeonardZim
    Regular Visitor
    1 year ago

    Thanks for your answer!
    I tried to do so but i still get the same error.
    I tried different versions of the my-sql connector: https://downloads.mysql.com/archives/c-net/
    What you mean by workbench and connector are the same version? I only have the connector installed on the Virtual Machine. The My-SQL Server is hosted by another company.

    Have you any other ideas?