Action.ViewFunction is a Power Query M function that wraps a given function in a way that can be intercepted by custom handlers defined in a view.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Action.ViewFunction( function as function ) as functionDescription
Creates a view function based on function that can be handled in a view created by Action.View.
The OnInvoke handler of Action.View can be used to define a handler for the view function.
As with the handlers for built-in operations, if no OnInvoke handler is specified, or if it does not handle the view function, or if an error is raised by the handler, function is applied on top of the view.
Refer to the published Power Query custom connector documentation for a more complete description of Action.View and custom view functions.
Related articles
Learn more about Action.ViewFunction 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
Related functions
Other functions related to Action.ViewFunction are:
- Action.DoNothing
- Action.Return
- Action.Sequence
- Action.Try
- Action.View
- Action.ViewError
- Action.WithErrorContext
2023-2026 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy