ValueAction.NativeStatement is a Power Query M function that creates an action to execute a statement against a target using specified parameters and options. The behavior of the action is defined by the target.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
ValueAction.NativeStatement( target as any, statement as text, optional parameters as any, optional options as nullable record, ) as any
Creates an action that executes
target using the parameters specified in
parameters and the options specified in
The behavior of the created action is defined by
target provides the context for the operation described by
statement describes the action to be taken against
statement is expressed in a manner specific to
target (for example, a T-SQL statement).
parameters value may contain either a list or record as appropriate to supply the parameter values expected by
options record may contain options that affect the execution behavior of
target. These options are specific to
The returned action will perform the described operation when executed. The action returns a meaningful value representing the outcome of the operation (for example, a status code, the number of rows affected, and so on).
The function will raise an evaluation error if invalid input arguments are detected (before trying to perform the operation).
The action will raise an execution error if the operation cannot be successfully completed.
target may be left in an undefined state if an execution error occurs.
Other functions related to ValueAction.NativeStatement are: