Facets Overview

Updated on

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.

Contribute » | Contributors: Rick de Groot
© 2024 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.