Gilbert Quevauvilliers runs a test:
In this blog post I am going to determine which item workload uses the least amount of Capacity Units when copying the same data from an On-Premises SQL Server.
The item workloads that I can use to copy data are Dataflow Gen1, Dataflow Gen2 and Pipelines.
Read on for the results, as well as one caveat about them.