Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello Power BI Community,
I'm experiencing an issue while trying to connect to an on-premise MySQL server using the On-Premises Data Gateway for Power BI scheduled-refreshes. I have successfully installed the data gateway, and it shows up in Power BI. However, when I attempt to add a new MySQL data source, I encounter an error stating that the "MySql.Data.MySqlClient" package cannot be found on the gateway system. I have also been able to use the gateway for an ODBC data source to my MySql server, so i know the connection is good.
Here is the error message I receive:
Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.
Details:
SQL-Server: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.
To troubleshoot the issue, I have taken the following steps:
Despite these efforts, I'm still encountering the same error. I am running a Windows Server with RDP access, and my goal is to use the data gateway to connect my on-premise MySQL server to Power BI scheduled-refreshes.
I would appreciate any guidance or suggestions on how to resolve this issue. Thank you in advance for your assistance!
Best regards,
Matt
Downgrade your /Net connector to 8.0.28
Downgrading the mysql to 8.0.28 is not an option but it because vulnurable to log4j.
Need another solution to stay on mysql connector 8.0.33
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.