Notifications
Clear all
Topic starter
05/10/2022 9:36 am
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
Suggested 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
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