BenchMark Quizzes by MDFT Pro

Discover Number Of Errors In Power BI Columns

You use Power BI Desktop to prepare data for MDFT Academy. You examine data quality in Power Query, focusing on identifying and resolving errors in your dataset.

You need to discover the number of errors in a column. Which two Data preview options should you use? Each correct answer presents a complete solution.

Choose all correct answers from the options below.

Explanations for each answer:

Column quality is correct. Column quality shows the percentage of valid, error, and empty values in a column.
Column distribution is incorrect. Column distribution shows the distribution of data for all columns, but not the number of errors.
Column profile is correct. Column profile shows statistics and the distribution of data for a column, including the number of errors.
Show whitespace is incorrect. Show whitespace displays white space characters in data cells, not the number of errors.

Learn more about data profiling in Power BI:

Power BI Data Profiling

Exam Preparation Quiz

Discover Number Of Errors In Power BI Columns