Microsoft Fabric Data Factory: unify and move data

Key insights

• The four-part summary is unify, orchestrate, transform and distribute.
• Pipelines coordinate data activities, while Dataflow Gen2 supports Power Query-based preparation.
• Copy jobs are used to move data into Fabric destinations.
• The supplied material does not specify licensing, rollout status or regional availability.

Microsoft Fabric Data Factory brings data integration tasks together to unify, orchestrate, transform and distribute data. It matters to data teams that need to move and prepare information for analytics across different sources and destinations. Reza Rad (RADACAD) [MVP] is the source of the demonstration framing these tasks in four words.

What it does

Fabric Data Factory is described in the supplied background as the data integration layer within Microsoft Fabric. Its purpose is to connect data sources, move data, prepare it for use and coordinate recurring work. The four verbs offer a practical way to think about an end-to-end data workflow, rather than four separate product features.

Unify refers to bringing data together in a shared Fabric data foundation. Orchestrate means coordinating activities in a pipeline, such as moving data and running a transformation. Transform covers preparing raw data, while distribute means delivering prepared data to a destination. The notes identify OneLake, Lakehouses and Warehouses as parts of this Fabric context.

Who it is for and what you need

This overview is relevant to data engineers, analysts and other teams building data workflows in Microsoft Fabric. The notes describe both visual, low-code approaches and code-based work, but do not state a specific role, license or plan requirement. They also do not establish a rollout stage, preview status or regional availability for the capabilities mentioned.

The supplied research says Fabric Data Factory connects to more than 170 sources, including cloud and hybrid systems, and notes that on-premises access can use gateways. Those figures and details are not independently verified here against an official Microsoft source. Check the relevant Microsoft documentation and your tenant before planning a production connection.

How it works

1. Connect to the source that contains the data you need.
2. Use a Copy job to move data, or build a pipeline to coordinate multiple activities.
3. Apply preparation through Dataflow Gen2, which uses a Power Query-based interface, or use code-based processing where needed.
4. Load or deliver the resulting data to a Fabric destination such as a Lakehouse or Warehouse.
5. Coordinate and monitor the workflow through the pipeline, according to the supplied background.

These are conceptual steps, not verified click-by-click instructions: the source material does not provide menu paths or configuration details. The right design depends on the sources, transformations and destinations involved.

Limitations and open questions

The supplied material does not identify required capacity, licensing, connector-specific limitations, exact setup steps or availability. It also does not explain how this approach compares in detail with a separately managed Azure Data Factory setup. Treat the four words as a summary of the workflow, not as a complete implementation guide.

Sources

• Reza Rad’s YouTube Short
• Original article by Reza Rad
• RADACAD website

Frequently asked questions

What are the four functions of Microsoft Fabric Data Factory?

The supplied material summarizes them as unify, orchestrate, transform and distribute: bring data together, coordinate work, prepare data and deliver it to destinations.

Does Fabric Data Factory require a specific license?

The supplied material does not state a license or capacity requirement. Confirm the applicable requirements in current Microsoft documentation before deployment.

What is the difference between a Fabric pipeline and Dataflow Gen2?

The notes describe pipelines as coordinating activities and Dataflow Gen2 as a Power Query-based way to prepare data. They do not give a detailed feature comparison.

Is Fabric Data Factory available in preview or in every region?

The supplied material does not establish rollout stage, preview status or regional availability.