Microsoft Certified: Power BI Data Analyst Associate Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  * Answer: To gain insight: Column Quality (it shows percentages of valid, error, and empty values). To resolve the errors: Replace Errors (we can replace error values with defaults or correct values).

• 2

  1. To gain insight into the number of errors: ✅ Column Quality In Power Query, turn on Column Quality (from the View tab). This displays a bar showing the percentage of Valid, Error, and Empty values for each column, so you can quickly see how many errors you have. 2. To resolve the errors: ✅ Remove Errors Right-click the column with errors → Remove Errors to filter out all error rows. Or, if you want to fix instead of remove, you could also use Replace Errors with default values. Final Answer: Gain insight: Column Quality Resolve errors: Remove Errors

• 2

  "Replace error" is correct, but the first block doesn't have any useful option. "Column distribution" shows distinct/unique count - not help at all, and if we have an error(our case) it shows nothing. "Column quality" shows the per cent valid/error/empty. OK, we have 52% of errors and what? What we really need here that the "Column profile" which shows all the information to identify the scope of error and replace errors.