Question

You are cleaning a 2-million-row sales table in Power Query Editor. You enable the Column quality and Column distribution features to check for data issues, but you notice the statistics seem to reflect only a small subset of rows. You need the profiling results to reflect all rows in the source before you finalize your cleaning steps. What should you do?

Accepted Answer

Change the column profiling setting at the bottom of the window from 'Column profiling based on top 1000 rows' to 'Column profiling based on entire data set'.

Answer

Increase the number of preview rows loaded by editing the 'Table.FirstN' step in the applied steps.

Answer

Disable Column quality and instead use the Data view statistics after loading the table to the model.

Answer

Add a 'Keep Top Rows' step set to 2,000,000 so the profiler evaluates every row.