Column Profiling Based on All Rows (Data Profiling)
Loving the new Data Profiling feature. I totally get the logic of only using the first 1000 rows of data to show the Column Profile. But similar to how in the "Filter" Dialog it gives me the option to "Load More". Would like the option to Load the Complete Profile of the Column based on all Data Rows. You can display a warning, if needed to warn the user that this may take a long time depending on the number of rows of data.
It would be nice if there was an option to do this on a specific Column or just say do this for all Columns being shown.
The M Query function Table.Profile can run the profiling for SQL Server sources using query folding. That's what I was expecting when I saw the Data Profiling announcements. It would be great if the new Data Profiling function can indeed do something similar.
Sounds like a great idea!