Which tool suits a low-code user cleaning a spreadsheet source?
Why A is the answer
Dataflow Gen2
Dataflow Gen2 offers a low-code Power Query experience.
In detail
- Dataflow Gen2 is low code, and suits cleaning a simple source.
- The steps are saved and repeat on each refresh.
Use case
An illustrative scenario, not a real incident.
A sales coordinator cleans a monthly spreadsheet with Power Query steps in Dataflow Gen2, with no code.
See it in different ways
flowchart TD
A{"Who builds it?"} -->|"Low-code users"| B["Dataflow Gen2"]
A -->|"Engineers, complex logic"| C["Notebook with PySpark"]
A -->|"SQL developers"| D["T-SQL in a warehouse"]mindmap
root((Fabric tools))
Pipeline
Copy
Schedule
ForEach
Notebook
Python
Complex logic
Dataflow Gen2
Low code
Triggers
Schedule
Eventflowchart LR S0["Connect to spreadsheet"] --> S1["Power Query steps"] --> S2["Write to destination"]
Key point: Dataflow Gen2 is low-code.
Why the other options are wrong
- B. A Spark notebook
- A notebook needs code.
- C. Spark structured streaming
- Streaming is not needed for a spreadsheet.
- D. A custom KQL function
- KQL is not a low-code cleaning tool.