Which component uses Power Query Online to transform data in Fabric?

• A. Dataflows Gen2
• B. Data Factory
• C. Real-time Intelligence
• D. Power BI Desktop

Answer: (A)

Power Query Online is the cloud-based data transformation experience embedded in the data preparation layer of Fabric. Dataflows Gen2 uses this Power Query Online capability to define and apply transformations—connecting to multiple sources, shaping, cleansing, and enriching data, and then storing the results in a dataflow for use by Fabric datasets or lakehouses. This makes it the go-to component for transforming data within Fabric.

Other options are not built on Power Query Online in Fabric: Data Factory focuses on orchestration and Spark-based data flows for transformations; Real-time Intelligence centers on streaming and real-time analytics; Power BI Desktop uses Power Query for data shaping, but its Transformation engine is separate from Fabric’s Power Query Online in dataflows.