How can we improve Power BI?

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.

23 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Avi Singh shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Matthias commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.