Power QueryExercises

Module 8

Profiling, errors and validation

Find and handle errors, missing fields and bad values with try … otherwise.

You'll be able to

Lessons

  1. 1.Find, remove and replace errorsHandle cell errors deliberately instead of letting them reach reports.
  2. 2.try … otherwiseCatch conversion errors inside an expression with a sensible fallback.
  3. 3.Profile columns before you trust themBuild a quick profile of a table's columns and read what it says about data quality.
  4. 4.Validate data and fail loudlyStop a refresh with a clear message when data breaks a business rule.

Take the profiling, errors and validation quiz (8 questions)

Exercises