Forum Discussion
Problem with Auto Refresh - SQL Server
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.
5 Replies
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
Many thanks@rajendraongole1 for your help. I changed to "not encrypted" and still get the same error
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
