Power Platform Community Forum Thread Details

416 RequestedRangeNotSatisfiable error with SFTP-SSH

Hi everyone,

The goal of my flow is to copy csv files stored on a remote server and paste them inside a SharePoint library. Many Power Bi then use thoses files to display data to clients.
For that, i used a SFTP-SSH connexion. I start by removing everything in the library, then i list the files on the remote server (with SFTP-SSH) and for each file, i get the file content and create the file in the library. (it may not be the most optimal way of doing it but it was simple and fast enough for my needs)

Screen translated via automatic translation

The thing is i'm encountering a few problems.

Firstly, the main problem is this 416 RequestedRangeNotSatisfiable error. I don't understand why or how. I looked on the forums and i have the impression that i am the only one to stumble upon this error with the SFTP-SSH action on the entire internet. (I've seen multiple persons saying to change the "content-length" on the header but this is for a HTTP API action, i don't i can change the "content-length" on a SFTP-SSH action.

Scecondly, the SFTP-SSH "get file content" action often gets a BadGateway error and retries a few times before succeding. It's not a huge problem since in the end, after many tries, it succeeds but i think it's worth mentionning.

Lastly, i often gets what seems like corrupted files. There is no error stopping the flow but i get a 4 byte csv file with a "null" text inside it.

further contexts :
- this is an old flow, at least a year old. It was working fine (except for the bad gateway retry error) until a few ago when the 4 byte corrupted files started appearing. the only thing i found to correct that is to store the id of the corrupted file (with a condition to check if a file size is 4byte or more) and to try to get the file content again. The 416 RequestedRangeNotSatisfiable started appearing since then. I don't know what i did to cause this. I tried to remove my modifications but the error remains.

- I discussed with the company providing the files on their remote server. They checked theirs logs and told me they have no errors with my connexions. They recommanded me to download the folder first before trying to access each file's data but i don't think it's possible with Power Automate.

- I tried different setup with the "apply to each", whether it is 50 parallel executions at a time, 10 or even 1 at a time, nothing is solving this.

Thanks in advance to anyone reading this and willing to help me.

Quick Links