Daily Refresh Failures on PBI Dataflows - Transport-Level/Decryption Errors

Hi, megane123 

Since this issue started occurring in mid-January, there may have been a change in the network configuration or security policy that affected the SSL connection. Please check with your web team to see if any updates or changes have been made at that time.

Even if the gateway is up to date, it's worth looking at its configuration. Ensure that the gateway is configured correctly for the SQL Server database connection. This includes checking to see if there are any specific SSL settings or certificates that need to be updated or reconfigured. For more details about configuring gateways for SQL Server, see Use on-premises data gateways with SQL Server:

Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn

Be sure to check the SSL configuration on SQL Server. Ensure that the server is properly configured to support SSL connections and that the certificate is valid and has not expired. For more information about SQL Server and SSL, you may find the Enabling Encrypted Connections to the Database Engine documentation helpful:

Configure SQL Server Database Engine for encryption - SQL Server | Microsoft Learn

If your dataflow is configured for incremental refresh, consider reviewing the settings. Sometimes, issues with the incremental refresh policy can lead to unexpected errors. For guidance on optimizing dataflow refreshes, including incremental refreshes, see Optimize dataflow refreshes:

Understand and optimize dataflows refresh - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.