A facet is used to both indicate a data type and provide additional information about the type. The M Language offers an extensive range of facets to provide additional information to destination application on what type of values to expect.
Available Type Claims
Power Query offers the following Type Claims:
| Facet | Base Type | Description |
|---|---|---|
| Any.Type | type any | The type that represents all values. |
| Binary.Type | type binary | The type that represents all binary values. |
| Date.Type | type date | The type that represents all date values. |
| DateTime.Type | type datetime | The type that represents all date and time values without an associated timezone. |
| DateTimeZone.Type | type datetimezone | The type that represents all date and time values relative to a timezone. |
| Duration.Type | type duration | The type that represents all duration values |
| Function.Type | type function | The type that represents all functions. |
| List.Type | type list | The type that represents all lists. |
| Logical.Type | type logical | The type that represents all logical values. |
| None.Type | type none | The type that represents no values. |
| Null.Type | type null | The type that represents null. |
| Byte.Type | type number | The type that represents all bytes. |
| Currency.Type | type number | The type that represents currency value. |
| Decimal.Type | type number | The type that represents fixed-point decimal number. |
| Double.Type | type number | The type that represents double precision floating point number. |
| Int16.Type | type number | The type that represents signed 16 bit integer. |
| Int32.Type | type number | The type that represents signed 32 bit integer. |
| Int64.Type | type number | The type that represents signed 64 bit integer. |
| Int8.Type | type number | The type that represents signed 8 bit integer. |
| Number.Type | type number | The type that represents all numbers. |
| Percentage.Type | type number | The type that represents percentage value. |
| Single.Type | type number | The type that represents single precision floating point number. |
| Record.Type | type record | The type that represents all records. |
| Table.Type | type table | The type that represents all tables. |
| Character.Type | type text | The type that represents all characters. |
| Guid.Type | type text | The type that represents a Guid value. |
| Password.Type | type text | The type that represents a text password. |
| Text.Type | type text | The type that represents all text values. |
| Uri.Type | type text | The type that represents a text URI. |
| Time.Type | type time | The type that represents all time values. |
| Type.Type | type type | The type that represents all types. |
2023-2026 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy