Get & Transform Interface and Applied Steps
Load CSV/Table sources into Power Query Editor, understand Applied Steps playback, and fix automatic Change Type traps.
Key takeaways while you watch
- Open Power Query from Data -> Get Data -> From Table/Range or From Text/CSV.
- Every click appends an editable step in Applied Steps — zero raw source cells are altered.
- Remove unwanted hard-coded column lists from auto-generated Change Type steps when columns change.
Drill: Spot Power Query's Case Sensitivity Rule
Is Power Query M formula syntax ('if', 'each', 'Text.Trim') case-sensitive? Answer Yes or No.
| Formula | Result |
|---|---|
| Text.Trim([Name]) | Valid M function |
| text.trim([Name]) | Expression.Error: name wasn't recognized |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.