Link to MySQL Using 8.0.33 Connector

[YBerllanWales]

Guys,

I am still getting the error "This connector requires one or more additional components to be installed before it can used." The link takes you to a web page to download the MYSQL Connector.

I have downloaded the connector which is version 8.0.33 and installed the connector. I have restarted my Laptop as well as Power BI and still I get the pop-up error. 

What am I not doing ????

[expertopinionsa]

Hi, to fix the error, add "ssl-mode=REQUIRED" under "Connection string options" when configuring your MySQL connection in Power BI. This ensures that your connection is secure and helps to protect sensitive data.I remember when I was working for a client with Triotech Systems this worked wonders. 

[Abhirup2001]

install everything in v8.0.32. server, router, workbench ,connectors.

[rhalabi]

I don't know how to fix, but if I can confirm it's an issue with the v8.0.33 driver. If you install v8.0.32 it works fine. The v8.0.33 driver does not work with the On-prem gateway or Excel also.

[YBerllanWales]

Hi

Anyone out their who has come across this issue with any help to resolve would be welcome. 

[AlexScott]

I think this bit from the release notes for the connector explains a few things ( from here )

Connector/NET no longer provides within the install and no-install bundles any third-party libraries that the connector does not build internally. Application developers must now ensure the availability of following libraries at run time.

For applications using OCI Authentication and SSL Certificates validation:

Portable.BouncyCastle (see https://www.nuget.org/packages/Portable.BouncyCastle)

Given that Power BI appears to require these connector assemblies to be in the Global Assembly Cache, I am not sure how 8.0.33 onwards can be used with Power BI if users would have to manually add these things themselves