Question

You are cleaning a 4-million-row sales table in Power Query Editor. In the status bar you enabled 'Column quality' and 'Column profile', but a colleague warns you that the error and empty percentages you see may not reflect the true state of the whole table. By default, what is the profiling based on, and what single action lets you validate the metrics against every row?

Accepted Answer

Profiling is based on the top 1,000 rows; click the profiling status message at the bottom and switch it to 'Column profiling based on entire data set'.

Answer

Profiling is based on the entire data set already; no change is needed because Power Query always scans all rows.

Answer

Profiling is based on a random 10% sample; disable and re-enable the Column profile checkbox to force a full scan.

Answer

Profiling is based on the top 1,000 rows; increase the sample by editing the 'Table.Profile' step in the Advanced Editor to pass all rows.