Power Query: stop repeating the cleanup

Power Query: stop repeating the cleanup

Profile your data

Inspect nulls, duplicates and data types before making changes. Keep a copy of the source and define what one row represents.

Transform repeatably

Use named transformation steps to trim text, split columns and assign types. Avoid deleting records without a documented rule. Practice: clean a region column containing extra spaces.

Refresh and validate

Refresh after adding source rows. Compare record counts and totals against the original. A successful refresh does not prove the values are correct.

Your next step

Try the exercises with a small dataset. Write down your assumptions, check the results against the source, and explain one thing you would improve.