Typically made by right-clicking a parameterised query and picking Create Function, this reusable Power Query function runs the same steps on each file or value. It keeps a link to the sample query it came from and is applied through Invoke Custom Function.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Custom function in context, with comparison tables and the common traps.
Terms in this definition
- CREATE FUNCTION
Adds a table function, or a Python or SQL UDF, to Unity Catalog so that it falls under governance like other objects. Doing so takes the relevant privilege on the schema.
- FUNCTION
Registered models count as functions in Unity Catalog, so this securable type governs them too: access is given through
GRANT ... ON FUNCTION, and REST calls passFUNCTIONassecurable_type. - Agents (classic) API
First-generation Foundry Agent Service API, based on threads, messages and runs. It is deprecated, replaced by conversations and responses, and retires on 31 March 2027.
- Invoke Custom Function
Runs a custom function against every row of a table in Power Query, placing each result in a new column. To make such a function in the first place, use Create Function on a query built around a parameter.
Related terms
- UDTF
Called from the
FROMclause, this custom function returns a table-like result of many rows and columns each time. It can live just in the session or, if written in Python, come under Unity Catalog governance.