Please enter your information to subscribe to the Microsoft Fabric Blog.

Thanks for subscribing to the Microsoft Fabric Blog. You’ll receive email notifications when we publish new posts.

Microsoft Fabric Updates Blog

  1. Updates
  2. All

Fast Copy with On-premises Data Gateway Support in Dataflow Gen2

Fast Copy boosts the speed and cost-effectiveness of your Dataflows Gen2. We loaded a 6 GB CSV file to a Lakehouse table in Microsoft Fabric with 8x faster and 3x cheaper result. See our last post for details.

Today, we’re excited to announce that Fast Copy in Dataflow Gen2 now supports high-performance data transfers from on-premises data stores using a gateway. You can use your existing on-premises data gateway in your Data Factory to access on-premise stores like SQL Server with Fast Copy in Dataflow Gen2.

Let’s see how it works. 

Assume that you have the on-premises data gateway installed and registered in your Data Factory as below.

Create your Dataflow Gen2, and you can access data from a SQL Server through that on-premises data gateway.

Click the Options button from Dataflow Gen2 pane to enable Fast Copy feature.

The indicator will also show you that your data will be loaded via Fast Copy after evaluating your data loading step.

After you finish all the configurations in Dataflow Gen2, publish it. You will see the copy activity engine is used to transfer your data from an on-premises SQL Server in a fast way.

More resources

Have any questions or feedback? Leave a comment below!

Related blog posts

Fast Copy with On-premises Data Gateway Support in Dataflow Gen2

Blog's featured image

Simplifying Data Ingestion with Copy job – Incremental Copy GA, Lakehouse Upserts, and New Connectors
July 1, 2025 by Ye Xu

Copy job has been a go-to tool for simplified data ingestion in Microsoft Fabric, offering a seamless data movement experience from any source to any destination. Whether you need batch or incremental copying, it provides the flexibility to meet diverse data needs while maintaining a simple and intuitive workflow. We continuously refine Copy job based … Continue reading “Simplifying Data Ingestion with Copy job – Incremental Copy GA, Lakehouse Upserts, and New Connectors”

Read more
Blog's featured image

On-premises data gateway June 2025 release
June 26, 2025 by Leo Li

The June 2025 release of the on-premises data gateway is (version 3000.274). What’s New Fabric pipeline – Azure database for PostgreSQL connector version 2.0 is now generally available. This new version is enhanced to support TLS 1.3, new table action – upsert, as well as the script activity in data pipeline.  Fabric pipeline – Enhanced … Continue reading “On-premises data gateway June 2025 release”

Read more