The MySql source doesn't support encrypted connections when i try to trying to automate the refresh

Hi Battar,

Thanks for reaching out to the Microsoft fabric community forum. It looks like you are facing an error related to encrypted connections when trying you are to schedule or trigger a refresh online. As you have already went through couple of solutions and workarounds, kindly go through few more workarounds to narrow down the issue. Some recent MySQL connector versions have caused provider errors with the gateway, so connector version mismatch is a frequent cause of this exact error. Enabling SSL on the server is an alternative fix because the service sometimes attempts an encrypted connection by default.

As you have akready checked the gateway machine, once verify if you can connect to X.XX.XXX.X:3306 (telnet / PowerShell / MySQL client). If the gateway is in a different environment (VM, Azure VM, etc.), ensure outbound/inbound rules allow the traffic and the MySQL user is allowed from the gateway host.

If none of the above help, at this point it may be worth opening a support ticket with Microsoft. You can reach out to Microsoft Support by raising a ticket with Microsoft Support. Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.

Hi Battar,

Power BI Service will only use your MySQL gateway data source if the dataset is mapped to the gateway entry that exactly matches the server name/port used in Desktop, and the gateway host must have a compatible MySQL connector installed. The "SslMode=none;" override is the usual fix when the gateway is trying to open an encrypted connection but your MySQL server doesn’t accept SSL. Kindly follow these steps in order and test after each one.

* Edit the gateway data source and add the connection string override. In PBI Service go to Settings (gear) then Manage gateways and select choose your gateway and click the MySQL data source you created. In the data source edit screen look for the Connection string override (sometimes under Advanced settings). Add "SslMode=none;".

* Now on the gateway machine restart the “On-premises data gateway” Windows service (or reboot the gateway VM). This makes sure the new connector/override is picked up.

* Makew sure the gateway has the MySQL client/connector. If you already have a connector installed, try a different version (some connector versions have caused issues with the gateway).

* Confirm dataset (gateway mapping and credentials). In Power BI Service go to your Workspace then go to Datasets and then the dataset and then Settings and then Gateway connection. Make sure the dataset is mapped to the same gateway data source entry you edited.

Now test connectivity from the gateway host and if you made changes while the dataset already existed in the service, republish the PBIX.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.