Column Quality in Power Query Editor

We can find the anomalies in the data in the Power Query Editor. Select View tab on the ribbon, and under Data Preview, select the Column Quality checkbox. The following figure shows the statistics that appear.

The following are the important points of column quality:

• Column quality graph is shown above the columns of data.
• Column quality shows us the percentages of data that is valid, in error, and empty. In an ideal situation, we want 100 percent of the data to be valid.

Note: By default, Power Query examines the first 1000 rows of our data set. To change this, select the profiling status in the status bar and select Column profiling based on entire data set.