Type.Type is a type facet in the Power Query M language. It represents the default type claim for the ‘type type’. It is used primarily for interacting with external systems like Power BI, where meta-type information is beneficial. The base type of ‘type type’ in Power Query is a meta-type provide additional details (such as indicating the definition of types themselves) to external systems or tools.
Examples
Generally, you will face a facet when transforming column types. You can transform a column into the specified type by using Table.TransformColumnTypes:
Table.TransformColumnTypes( Source, {{ "myColumn", Type.Type }} )
Or when adding a column using Table.AddColumn:
Table.AddColumn( Source, "myColumn", type text, Type.Type" )
To inspect the kind of value you are dealing with, you can make use of the Table.Schema function. Applying it to a table returns a table with information about your columns. The Table.SingleRow function then transforms the result into a record, for easier reading.
let
a = type text,
// Ascribes the default type claim facet for 'type type'
b = Value.ReplaceType( a, Type.Type ),
// Returns a table containing a value with the ascribed "Type.Type"
c = #table(type table [Col1 = Value.Type( b ) ], { b } ),
// Shows the Table information, including typeName and value kind
d = Table.Schema( c ),
// For easier viewing, return table as record
e = Table.SingleRow( d )
in
e
Related facets
Other related facets are:
- Any.Type
- Binary.Type
- Byte.Type
- Character.Type
- Currency.Type
- Date.Type
- DateTime.Type
- DateTimeZone.Type
- Decimal.Type
- Double.Type
- Duration.Type
- Function.Type
- Guid.Type
- Int16.Type
- Int32.Type
- Int64.Type
- Int8.Type
- List.Type
- Logical.Type
- None.Type
- Null.Type
- Number.Type
- Password.Type
- Percentage.Type
- Record.Type
- Single.Type
- Table.Type
- Text.Type
- Time.Type
- Uri.Type
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy