Fabric SQL Database not a supported destination for Fast Copy?

[frithjof_v]

The error message says that Fast Copy is not supported for any of the data sources in the expression.

However, the exact same dataflow is able to write to a Lakehouse and a Warehouse, using the same data sources and using Fast Copy.

Does it mean that Fabric SQL Database is not supported as a destination for Fast Copy?

[v-yilong-msft · Accepted solution]

Hi @frithjof_v ,

It sounds like you're encountering a limitation with Fast Copy in Microsoft Fabric. Based on the information available, Fast Copy is supported for several data sources, including Azure SQL Database, Lakehouse, and Warehouse. However, it seems that Fabric SQL Database might not be supported as a destination for Fast Copy at this time.

If you need to use Fast Copy, you might consider staging your data in a supported destination like a Lakehouse or Warehouse first, and then moving it to the Fabric SQL Database.

Also I think you can read this two documents below:

Copy activity performance with SQL databases - Microsoft Fabric | Microsoft Learn

Fast copy in Dataflows Gen2 - Microsoft Fabric | Microsoft Learn

Best Regards

Yilong Zhou

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