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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors