Which Data Preview option should you select?

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?
A . Show whitespace
B . Column profile
C . Column distribution
D . Column quality

View Answer

Answer: D

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 quality

– Column distribution

– Column profile

Reference: https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April­2019/ba-p/674555