You open a query in Power Query Editor. You need to identify the percentage of empty values in each column as quickly as possible. Which Data Preview option should you select?

The correct answer is D. Column quality. Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table. Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities: Column…

Submitted by haruto_sh· Apr 18, 2026Prepare the data

Question

Options

AShow whitespace
BColumn profile
CColumn distribution
DColumn quality

How the community answered

(71 responses)

A
4% (3)
B
1% (1)
C
1% (1)
D
93% (66)

Explanation

Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table. Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities: Column distribution https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update- April- 2019/ba-p/674555

Topics

#Power Query Editor#Column Quality#Data Profiling#Empty value detection

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice