Power BI Report Server can not connect to MySQL v8

Hello

when we connect to a MySQL v8 in SaaS through MySQL connector/NET Power BI desktop allows us to indicate that the communication will be encrypted, and Power BI Desktop connects without problem to MySQL.

The issue appears when publishing the dashboard to Power BI Report Server, as configuring the dashborad connection from the Power BI Report Server portal does not connect to MySQL and the following error appears:

MySQL: Authentication to host 'XXXXXXXXXX for user 'OXXXXXX' using method 'mysql_native_password' failed with message: Connections using insecure transport are prohibited while --require_secure_transport=ON.

How can we tell or force you to encrypt the connection?

Best regards

Victor