| Connect and Profile |
| Connect to Sources |
File, database, and online connectors covered by PL-300 |
| Profile Data |
Column quality, distribution, and profile views in the editor |
| Power Query Steps |
Common transformations such as merges, appends, and pivots |
| Data Types |
Setting types so DAX and visuals behave predictably |
| Shape and Refresh |
| Privacy Levels |
Public, organisational, and private classifications for source data |
| Parameters |
Reusable inputs that adapt queries to environments |
| Query Folding |
Letting source engines do the work for performance |
| Refresh Strategy |
Choosing import refresh schedules and incremental options |