Handle Power Query Refresh Failures with the Right Battlecard

Schema drift The supplier added a column. Can we just delete it before refresh? Your line First check whether the query selected columns by position or by name. Fix the contract, then add a missing/extra-column check. Manual pre-cleaning the file every cycle. It repairs the reusable transformation instead of adding hidden prep work. Type error The date column broke again. Should I format the CSV manually? No. Keep the source untouched, set the type in the query, and route rows that cannot convert into exceptions. Editing raw files until the query stops complaining. Bad dates are data-quality signals, not chores…

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in