topic Re: Fabric with Virtual Network in Developer

Fabric with Virtual Network

trivediasit — Tue, 02 Apr 2024 20:02:47 GMT

I have an SFTP server in a Private Network. I wish to get data from the SFTP server into Microsoft Fabric using A pipeline. please share the steps and config settings I need to make / change?

I tried setting up the gateway, that didn't work. I was missing something.

Re: Fabric with Virtual Network

Anonymous — Wed, 03 Apr 2024 05:55:01 GMT

Hi @trivediasit ,

Please make sure that the gateway is in the same machine with SFTP server or the SFTP server is accessible from the machine where the gateway is installed.
Then you need to have the necessary permissions to access the SFTP server and the files you intend to transfer.

You can refer to below offical blogs to learn how to install and configure gateway.

With the gateway in place, you can now configure the SFTP connector in your Microsoft Fabric pipeline:

In your Fabric pipeline, select the Copy Data activity.
For the source, choose the SFTP option and provide the necessary connection details, including the server address, port, and authentication credentials.

For reference:

SFTP connector overview

Configure SFTP in a copy activity - Microsoft Fabric | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Fabric with Virtual Network

trivediasit — Wed, 03 Apr 2024 08:19:01 GMT

Hi Rico

Thanks a lot for the detailed process. I came across this:

https://learn.microsoft.com/en-us/data-integration/vnet/overview

Limitations

Currently, this feature is available only for Fabric Dataflow Gen2, Power BI semantic models, Power Platform dataflows, and Power BI paginated reports. Power BI dataflows and datamarts are not supported

-----------------------------------------------------------

I wasn't sure if Copy Data Activity in a pipeline is supported.

It'll be great to find a reference.

Thanks a lot.

Cheers

Asit