Action.DoNothing - Custom Connector Functions

Action.DoNothing is a Power Query M function that defines an action that performs no operation and returns null when executed.

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

Syntax

Action.DoNothing( action as any ) as any

An action that performs no action when executed and returns null as its result.

Learn more about Action.DoNothing in the following articles:

M Mysteries: The Mysterious Type Action—An M-Internal Means to Write Data Modifications to External Systems
In his article “M Mysteries: The Mysterious Type Action,” Ben Gribaudo explores Power Query’s hidden capability to perform data modifications—such as inserts, updates, and deletes—using the undocumented ‘action’ type. Although Power Query is primarily designed for data retrieval and transformation, Gribaudo reveals that it possesses internal functions that can interact with external data sources to modify data. These functions, however, are not intended for general use and require the Power Query SDK for implementation. » Read more

Other functions related to Action.DoNothing are:

Contribute » | Contributors: Rick de Groot