Data profiling in Query Editor

This has emerged from a few months in preview darkness, blinking into the light. 

Suppose you've loaded a list of Abba songs (surely a typical use for Power BI?), and you want to know at a glance how reliable the data is:

Mamma mia! The songs look good, but what are all those gaps?

You can let your mouse linger over the thin bluey-green strip to see an analysis of the quality of any column:

Two album names are missing.

From here it's really easy to decide what to do about the missing (or in some cases, duplicate) data:

You could choose this option, for example, to remove any rows with no album names.

But you could go further.  How about a histogram showing the distribution of column values?

These column distributions show the distribution of values in each column.

Or even a full breakdown for any column you click on?

This is called a column profile.

You can turn these - and more - options on by ticking the appropriate boxes on the View tab of the Query Editor ribbon:

These are the two options I ticked to get the features shown above.

All in all, a really nice, quick, simple way to check for obvious errors in your data before you start trying to tidy it up!