PL-300 - Prepare the Data (24% of the exam) - Section 1.3

Profile and examine data to assess quality, structure, and distribution.

Interpret column quality, column distribution, and column profile statistics to locate errors, nulls, and data anomalies before loading. Distinguish between removing, replacing, or keeping null values based on the downstream impact on measures and relationships.

column qualitycolumn distributioncolumn profileerror and null handlingdata anomalies

Practice question for this objective

Free samplePrepare the Dataeasy

An analyst opens the Power Query Editor in Power BI Desktop and wants to turn on the column quality and column distribution features. Which ribbon tab exposes those options?

AThe Home tab, in the Reduce rows group, exposes the column quality and column distribution toggles.
BThe Transform tab, in the Any column group, exposes the column quality and column distribution toggles.
CThe View tab, in the Data preview group, exposes the column quality and column distribution toggles. Correct
DThe Add Column tab, in the General group, exposes the column quality and column distribution toggles.

Column quality, distribution, and profile are enabled on the View tab in the Data preview group. The data profiling tools article documents that to enable them in Power Query Desktop, the user goes to the View tab on the ribbon and enables the options in the Data preview group.

Why A is wrong: The Reduce rows group on the Home tab contains row-removal commands such as Remove errors and Keep rows, not data profiling toggles.

Why B is wrong: The Any column group on the Transform tab contains transformations such as Detect data type and Replace values, not profiling toggles.

Why C is correct: Correct. The data profiling tools article documents that to enable them in Power Query Desktop, the user goes to the View tab on the ribbon and enables the options in the Data preview group.

Why D is wrong: The General group on the Add Column tab contains custom and conditional column builders, not the data profiling preview toggles.

See more PL-300 practice questions, answers explained.

Exam traps in Prepare the Data

Answers that look right on this material and are not. Each one is a distractor from a different question in the PL-300 bank for this domain.

Duplicate values, shown in orange under the column heading.
Why it is wrong: Column quality does not flag duplicates as a category. Duplicates surface through Distinct and Unique counts in column distribution, not in quality.
Detect errors, available on the Add Column tab in the General group under Custom column.
Why it is wrong: There is no Detect errors command. Identification of cell errors comes from column quality profiling, not from a Detect errors transform.
Yes
Why it is wrong: Only step-level errors block loading. Cell-level errors propagate into the loaded model as error values for the affected rows, and visuals may show those rows as blank or with an error indicator, but the load itself completes.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.