Enumerations in the Power Query M language are used to define a fixed set of possible values for a function argument. They help improve the accuracy and readability of the code by limiting the available options to a specific list of choices.
Enumerations in Power Query M
Below you will find a comprehensive table of all the enumerations available in the M language, along with a brief description of each one.
Data Manipulation
| Argument | Description |
|---|---|
| BinaryOccurrence.Type | Specifies how many times the item is expected to appear in the group. |
| Occurrence.Type | Specifies the occurrence of an element in a sequence. |
| Order.Type | Specifies the direction of sorting. |
| PercentileMode.Type | Specifies the percentile mode type. |
| Precision.Type | Specifies the precision of comparison. |
| RankKind.Type | Specifies the type of ranking. |
| RoundingMode.Type | Specifies rounding direction when there is a tie between the possible numbers to round to. |
Data Source and Integration
| Argument | Description |
|---|---|
| AccessControlKind.Type | Specifies the kind of access control. It was added for a scenario which isn’t relevant any more. Therefore the function doesn’t currently have any practical use. |
| HiveProtocol.Type | Specifies the Thrift Transport Protocol to use when connecting to a Hive server. |
| ODataOmitValues.Type | Specifies the kinds of values an OData service can omit. |
| SapBusinessWarehouseExecutionMode.Type | Valid options for SAP Business Warehouse execution mode option. |
| SapHanaDistribution.Type | Valid options for SAP HANA distribution option. |
| SapHanaRangeOperator.Type | A range operator for SAP HANA range input parameters. |
| SparkProtocol.Type | Specifies the protocol to use when connecting to an instance of Spark. |
Encoding and Compression
| Argument | Description |
|---|---|
| BinaryEncoding.Type | Specifies the type of binary encoding. |
| Compression.Type | Specifies the type of compression. |
Error Handling
| Argument | Description |
|---|---|
| ExtraValues.Type | Specifies the expected action for extra values in a row that contains columns more than expected. |
| MissingField.Type | Specifies the expected action for missing values in a row that contains columns less than expected. |
File and Text Processing
| Argument | Description |
|---|---|
| BufferMode.Type | Describes the type of buffering to be performed. |
| ByteOrder.Type | Specifies the byte order. |
| CsvStyle.Type | Specifies the significance of quotes in Csv documents. |
| LimitClauseKind.Type | Describes the type of limit clause supported by the SQL dialect used by this data source. |
| QuoteStyle.Type | Specifies the quote style. |
| RelativePosition.Type | Indicates whether indexing should be done from the start or end of the input. |
| TextEncoding.Type | Specifies the text encoding type. |
Join and Grouping
| Argument | Description |
|---|---|
| GroupKind.Type | Specifies the kind of grouping. |
| JoinAlgorithm.Type | Specifies the join algorithm to be used in the join operation. |
| JoinKind.Type | Specifies the kind of join operation. |
| JoinSide.Type | Specifies the left or right table of a join. |
Miscellaneous
| Argument | Description |
|---|---|
| Day.Type | Specifies a day of week. |
| TraceLevel.Type | Specifies the trace level. |
| WebMethod.Type | Specifies an HTTP method. |
2023-2026 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy