Skip to main content

Power BI

Completed

Column Profiling Based on All Rows (Data Profiling)

Vote (23) Share
Avi Singh's profile image

Avi Singh on 21 Oct 2018 09:19:49

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.

Administrator on 13 Apr 2019 01:54:29

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!

Comments (3)
Avi Singh's profile image Profile Picture

8a32d07c 1082-4d67-bc71-e8dd7e27b473 on 05 Jul 2020 23:45:19

RE: Column Profiling Based on All Rows (Data Profiling)

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.

Avi Singh's profile image Profile Picture

e59eabbd 4529-41e3-91e9-10ab3f5bdc40 on 05 Jul 2020 23:36:01

RE: Column Profiling Based on All Rows (Data Profiling)

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.

Avi Singh's profile image Profile Picture

9ae47809 b671-4b43-8b7b-ea83968ab771 on 05 Jul 2020 23:32:55

RE: Column Profiling Based on All Rows (Data Profiling)

Sounds like a great idea!