Enhancements to Data Profiling

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, or analysts, automatically - This feature is released. Oct 14, 2019

Feature details

Data Profiling is one of the most acclaimed features by Power Query customers. Based on customer feedback, we're continuing to expand Data Profiling capabilities to include the following:

  • Taking action from within Data Profiling UI controls: Includes the ability to apply value-based filters (equals, does not equal, starts with, ends with, contains, and more).
  • Enabling richer exploration of data profiles: Includes the ability to group data by using different criteria based on column data types, such as value length (for text columns), year, quarter, month, day, and so on (for date columns), even, odd, positive, and negative (for number columns), and more.
  • Allowing customers to export data profiling information: Supports the ability to export to a clipboard or a CSV file, so that the data is easily shared with others within an organization (such as other data analysts or the owners of a problematic data source).

See also

Power BI Desktop October updates (blog)