BenchMark Quizzes by MDFT Pro

Identify Unique Values In Power BI Columns

You use Power BI Desktop to prepare data for MDFT Academy. You import a set of data using Power Query, which includes several columns that must be unique for accurate reporting.

You need to identify whether a column contains only unique values. Which two data preview options can you use to meet your goal? Each correct answer presents a complete solution.

Choose all correct answers from the options below.

Explanations for each answer:

Column summary is incorrect. Column summary is not an existing data preview option.
Column profile is correct. Column profile shows statistics and the distribution of data for a column, including the number of unique values.
Column distribution is correct. Column distribution shows the distribution of data for all columns, including unique values.
Column quality is incorrect. Column quality shows the number and percentage of valid, error, and empty values, but not uniqueness.

Learn more about data preview options in Power BI:

Power BI Data Preview Options

Exam Preparation Quiz

Identify Unique Values In Power BI Columns