Forum Discussion
Fabric with Virtual Network
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.
2 Replies
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:
Configure SFTP in a copy activity - Microsoft Fabric | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
