Problem with Auto Refresh - SQL Server

[emutuc]

I am having issues getting Power BI to automatically refresh. I'd like to send out daily reports with the latest data.

I get the following error:

Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

The MySql source doesn't support encrypted connections.  The exception was raised by the IDbCommand interface. Table: Query1.

Any idea how to resolve? Many thanks in advance for your time to help me.

[rajendraongole1]

Hi @emutuc  - In Power BI data connections, can you check the settings 

Go to Data Source Settings → Select your MySQL connection>>Click Edit Permissions → Under Encryption, select "Do not encrypt">>Save and test the connection

reference link:

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

On-premises data gateway - Power BI | Microsoft Learn

[emutuc]

Many thanks@rajendraongole1 for your help.  I changed to "not encrypted" and still get the same error

[emutuc]

hello @rajendraongole1 do you have any more suggestions.  This is the error message I get 

Data source error: The MySql source doesn't support encrypted connections. (Source at 144.208.70.101;nexusb8_app_insights.). The exception was raised by the IDbCommand interface. Table: Query1.
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
Activity ID: b6dc4973-e78c-4b64-a9c5-26c354d75762
Request ID: a68e39de-5ba2-463b-bc32-30ac2eb530a4
Time: 2025-03-19 17:24:07Z

[rajendraongole1]

Hi @emutuc  - can you run the command in mysql

SHOW VARIABLES LIKE 'require_secure_transport';

If it returns ON, the server requires SSL, and Power BI won't connect without an encrypted session.
If it returns OFF, unencrypted connections are allowed.

disabled it by using below command, if it is turn on.

SET GLOBAL require_secure_transport = OFF;

check the mysql version also, if you are using older it may not support to fetch via power bi. 

Hope this helps.

[emutuc]

@rajendraongole1 Nothing happens after I type "SHOW VARIABLES LIKE 'require_secure_transport';
Do you have any other suggestions?