Updated on

ValueAction.Replace is a Power Query M function that creates an action to replace the content of a value with a specified value. This function raises an error if the target is not updatable or if the source is not compatible with the target.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


   target as any,
   source as any,
) as any


Creates an action that when executed replaces the content of target with source.

The function raises an evaluation error if target is not updatable or if source is not compatible with target.

The action raises an execution error if the operation fails.

NOTE: target may be left in a partially updated state if an execution error occurs.

Other functions related to ValueAction.Replace are:

Contribute » | Contributors: Rick de Groot