ValueAction.Replace

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

Syntax

ValueAction.Replace(
   target as any,
   source as any,
) as any

Description

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.

Related functions

Other functions related to ValueAction.Replace are:

• ValueAction.BeginTransaction
• ValueAction.CommitTransaction
• ValueAction.NativeStatement

Contribute » | Contributors: Rick de Groot