What causes FtpFailedToReadFtpData?

The FTP connection was dropped mid-transfer (unstable network between the integration runtime and the FTP server). The FTP server enforced a data transfer timeout and closed the connection before the file was fully read. The file on the FTP server was deleted or moved by another process while ADF was reading it. Passive mode vs. active mode mismatch between the ADF linked service configuration and the FTP server

How do I fix FtpFailedToReadFtpData?

Add a retry policy to the copy activity to handle transient FTP read failures.. Verify the FTP server's passive/active mode setting matches the mode configured in the ADF linked service.. Check network stability between the self-hosted integration runtime and the FTP server.. Confirm the file still exists on the FTP server and is not being modified during the ADF read.. Increase the FTP data channel timeout in the linked service if transfers are timing out on large files.

High severitydata source

Power BI Refresh Error:
FtpFailedToReadFtpData

What does this error mean?

ADF connected to the FTP server but failed to read the file during transfer — the error occurs during the data download phase, not the initial connection.

Common causes

1The FTP connection was dropped mid-transfer (unstable network between the integration runtime and the FTP server)
2The FTP server enforced a data transfer timeout and closed the connection before the file was fully read
3The file on the FTP server was deleted or moved by another process while ADF was reading it
4Passive mode vs. active mode mismatch between the ADF linked service configuration and the FTP server

How to fix it

1Add a retry policy to the copy activity to handle transient FTP read failures.
2Verify the FTP server's passive/active mode setting matches the mode configured in the ADF linked service.
3Check network stability between the self-hosted integration runtime and the FTP server.
4Confirm the file still exists on the FTP server and is not being modified during the ADF read.
5Increase the FTP data channel timeout in the linked service if transfers are timing out on large files.

Frequently asked questions

Does this error affect all pipeline runs or just the current one?

Depends on the root cause. A persistent misconfiguration fails every run; a transient issue may resolve on retry. Check the run history.

Can this error appear in Azure Data Factory and Microsoft Fabric pipelines?

Yes — the same connector errors appear in both ADF and Fabric Data Factory pipelines.

How do I see the full error detail for an ADF pipeline failure?

In ADF Monitor, click the failed run, then the failed activity. The detail pane shows the error code, message, and sub-error codes.

Will downstream Power BI datasets be affected when an ADF pipeline fails?

Yes — a dataset refreshing after the pipeline will use stale data or fail if the target table was cleared. The Power BI refresh may succeed while serving wrong data.

Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-ftp-sftp-http