Updated on

Int16.Type is a type facet in the Power Query M language. It represents one of the type claims belonging to ‘type number’. It is used for numerical data requiring moderate precision, often in medium-scale data processing. The base type of ‘type number’ in Power Query is a general numeric type, but facets like Int16.Type provide additional details (like representing 16-bit integers) for external systems or tools requiring specific numeric precision.


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", Int16.Type }} )

Or when adding a column using Table.AddColumn:

Table.AddColumn( Source, "myColumn", 99, Int16.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.

  a =  99,
   // Ascribes a type claim facet for 'type number'
  b = Value.ReplaceType( a, Int16.Type ),
  // Returns a table containing a value with the ascribed "Int16.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 )

Related facets

Other related facets are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot