Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
trivediasit
Regular Visitor

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 2
v-rzhou-msft
Community Support
Community Support

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.

  1. Download and install the gateway.
  2.  Configure the gateway.

 

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

  1. In your Fabric pipeline, select the Copy Data activity. 
  2. 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.

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.