Examining the global environment
In Power Query M, the global environment refers to the top-level scope that encompasses the entire Power Query query. It represents the highest level of visibility and accessibility for variables and functions, making them available throughout the entire query’s code. The global environment serves as a container for global variables, functions, and settings that can be accessed and used across all query steps and functions.
When creating queries within Power Query Editor in Power BI Desktop, the global environment comprises the following three components:
- Standard library: A programming language’s standard library is a non-volatile collection of resources such as configuration data, documentation, classes, values, types, and pre-written code. M’s standard library consists of the following elements:
- Built-in functions
- Built-in types
- Built-in enumerations
- Shared extension...
