azure-data-factorysftpconnectormicrosoft-fabric

use private key authentication with ms fabric sftp connector

I'm trying to build an end to end analytics flow in Microsoft Fabric, using the fabric data factory to read files on an sftp server and load them to onelake so I can then push into datasets and report on them in power bi.

The fabric SFTP connector only has basic authentication:

enter image description here

, but I need to use a private keyfile and SSH auth instead

In Azure Data Factory, the sftp connector allows SSH auth & keyfiles:

enter image description here

Is there a different connector I could / should use in fabric?

Solution

  • As per this Ms document

    only Basic authentication is supported for SFTP connector in Microsoft Fabric.

    enter image description here

    If you only want to authenticate with the SSH auth & key files you need to use ADF.

    You can raise a feature request about adding authentication options for SFTP connector as ADF here.