Question

You are preparing a customer table in Power Query Editor. Before loading the data, you need to quickly identify what percentage of rows in the 'Email' column contain valid values, error values, or empty values across the entire dataset (not just the first 1,000 rows). Which combination of Power Query features should you enable?

Accepted Answer

Enable 'Column quality' and set the profiling scope to 'Column profiling based on entire data set'.

Answer

Enable 'Column distribution' and keep the default profiling scope of 'Column profiling based on top 1000 rows'.

Answer

Enable 'Column profile' and set the profiling scope to 'Column profiling based on top 1000 rows'.

Answer

Add a custom column using an if statement to flag blank and error values, then group by the flag.