Result of the destination check: No RFC authorization for function module TH_SERVER _LIST.

This error message usually indicates that one of the prerequisites is not met in the on-premise source system.

Implementing 2703850 Information published on SAP site should fix the issue. For more information, see Add the SAP Datasphere Subaccount in the Cloud Connector.