Share via

Parity with Power Query Desktop

  • 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

Many features that are present in Power Query Desktop are being brought to Power Query Online to significantly improve the query development and management experiences and the interface. These improvements include a significant number of tweaks. The areas of focus include:

  • Automatic column type detection.
  • Data Transformations, including fill up, fill down, pivot, extract text before/after/between delimiters, keep/remove characters, split by character transition, append queries, combine files, and more.
  • Venn diagram icons in merge dialog to represent join types.
  • Security and authentication features, including support for privacy levels and encryption warnings.
  • Support for query parameters in the user interface.
  • Parameters experience and the ability to bind to query parameters from input controls in specific operations. These include connector dialog boxes (for URLs and paths) and the most commonly used transformations (split columns, replace values, filter rows, and so on).
  • Function creation and invocation user experience, enabling users to easily convert queries with parameters into functions that are easily invoked from other queries.
  • Steps pane improvements to allow advanced authoring capabilities such as reordering steps, support for descriptions for any step, or refactoring base query steps into new queries for easy reusability.
  • Query groups improvements, including the ability to move queries between groups and reorder groups.
  • Queries pane improvements, including the ability to easily reorder queries and manage other query properties from the queries pane.
  • Navigator parity items, including related tables, refresh tree, refresh preview, only selected items, other display options, and more.
  • IntelliSense support in the formula bar and advanced editor dialog box.