Smart data preparation

  • Article

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 31, 2019

Feature details

A continuing goal for Power Query and Power Query Online is to make data preparation smarter. This enables analysts to have artificial intelligence (AI) capabilities at the touch of a button, enriching and enhancing data. In addition to the AI insight capabilities that are already in Power Query Online for Power BI Dataflows, two new smart data preparation capabilities will be added:

  • Fuzzy Merge: Allows users to easily combine data from multiple tables by using fuzzy matching algorithms instead of strict matching.
  • Data Profiling: Helps users easily identify error, empty, and outlier values within their Power Query Editor data previews.