SFTP - SSH first PowerBI Automate attempt

[JeroenWilke]

Hi!

I'm trying to pull a file from an SFTP server and unfortunately I am running into trouble right from the start because the SFTP connection cannot be established due to "BadGateway"

When I look at the developer tools network debug I get a bit more useful info:

No suitable authentication method found to complete authentication (publickey,keyboard-interactive).

I'm using simple username/password validation for my test, of which I know the credentials work, the sftp server itself has no inbound firewalling in place, nor does my azure tenant.

Aside from contacting the external party that hosts the SFTP server I am unsure what my next step should be from the Power Automate side of  things.

[JeroenWilke · Accepted solution]

So, I ended up solving this by using public key authentication.

I'm not sure if this is a requirement for SFTP-SSH, at least it is not apparent to me after reading the documentation but it worked so I'm happy.

[RenNakanote]

I Am always glad to hear when a programmer’s install a thon goes well! 😄

[Mari]

Thanks for updating the thread!