Microsoft Fabric Updates Blog

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!

関連するブログ記事

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

1月 20, 2026 作成者: Aaron Merrill

OneLake security now supports Mirrored Databases in Microsoft Fabric with the ability to define OneLake data access roles on all Mirrored item types. This update brings granular, role-based access control to data replicated into OneLake from transactional systems, extending the OneLake security model beyond lakehouses and enabling secure reuse of mirrored data across the organization. … Continue reading “Manage OneLake security for Mirrored Databases (Preview)”

1月 20, 2026 作成者: Ye Xu

Copy job is the go-to solution in Microsoft Fabric Data Factory for simplified data movement, whether you’re moving data across clouds, from on-premises systems, or between services. With native support for multiple delivery styles, including bulk copy, incremental copy, and change data capture (CDC) replication, Copy job offers the flexibility to handle a wide range … Continue reading “Simplifying data movement across multiple clouds with Copy job – Enhancements on incremental copy and change data capture”