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?