Failed to copy data from SFTP

Hi cheryl0316 ,

Thanks for using Microsoft Fabric Community to post your query.

This error typically occurs when the Fabric pipeline runtime cannot reach the SFTP server on port 22. The connection test in Manage Connections only validates the credentials, but the actual Copy activity runs from the managed Fabric environment, and that environment must have direct network access to the SFTP host.

Firewall rules or network restrictions on the SFTP server can prevent the SSH session from being established. When that happens, the server closes the connection and the pipeline reports the error you’re seeing.

You can review the SFTP connector behaviour here:
SFTP connector overview - Microsoft Fabric | Microsoft Learn
Configure SFTP in a copy activity - Microsoft Fabric | Microsoft Learn

For reference, other discussions reporting the same behaviour are here:
Solved: SFTP connection fails in Fabric - Microsoft Fabric Community
Solved: Internal Error Occurred - SFTP Connection - Microsoft Fabric Community
Solved: SFTP connection fails - Microsoft Fabric Community

Updating the SFTP network rules to allow access from the Fabric service should resolve the issue.

Hope this helps. Please reach out for further assistance.
Thank you.