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.
We’re glad to let you know that this feature is now Generally Available. Please refer to the Power BI Desktop April release announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/
Thanks for your feedback!
Having profiling outside of Power Query would be great too. Business users/consumers could get a lot of value from data profiling/statistical features. Kaggle datasets are a great example of what this could look like, but allow the ability to add in our own features through DAX.
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!