How-To Geek on MSN

Stop deleting columns in Power Query: Do this instead

Protect your reports from source data changes by defining exactly which columns Power Query should keep, not remove.
How-To Geek on MSN

Stop ignoring the Applied Steps pane: 5 Power Query tricks for faster data cleanup

Master non-destructive edits, troubleshoot errors, and document your logic to build resilient, automated Power Query ...