In Power BI, which Power Query option helps you identify the percentage of valid records in a column before loading to the report?

• A. Column quality
• B. Column profiling
• C. Column distribution
• D. Column statistics

Answer: (A)

Column quality is the feature that shows how clean a column is by presenting the percentage of values that are valid, errors, or empty. In Power Query Editor, enabling column quality gives you a quick snapshot of what portion of records in a column are valid before you load the data into the report. This helps you decide whether cleansing steps or filtering are needed before loading.

Column profiling adds deeper details like distributions and statistics, but it doesn’t focus on the explicit valid/invalid split. Column distribution and Column statistics provide value frequencies or numeric metrics rather than a direct validity percentage.