Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
MattKA
New Member

Unable to connect to on-premise MySQL server using Data Gateway for Power BI scheduled-refreshes

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:

  1. Installed and re-installed .NET Framework, MySQL Connector/NET, and MySQL Connector/ODBC.
  2. Registered the MySql.Data.dll in the Global Assembly Cache (GAC).
  3. Copied the MySql.Data.dll file to the On-Premises Data Gateway installation folder and restarted the gateway service.

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

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

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 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors