Only 64-Bit Data Type in Data Models?

[ovetteabejuela]

Read: Data Types in Data Models

Does this mean that no matter how I customzie my data types in Data Models down to Int8 it will always be converted to Int64?

But I did observe something, If I convert the data type to Int8 it can only accept a number not greater than 127 or 0111 1111.

[MarcelBeug]

Almost correct. Numbers are stored in 64-bit; depending on the data type these can be integers or (floating point) decimals.

The range for Int8 = -128 thru 127.

[ovetteabejuela]

So, does this mean I had to stop micromanaging my data types - the Int ones?

What I'm doing is I'm going through each one and evaluating their ranges (Int8, Int 16, Int32, Int64).

[MarcelBeug · Accepted solution]

In my view, the Int.. types can only be used to have an error generated if a number is outside its range (see below), except for Int64 which is the general type for whole numbers.

Int8: -256 - +255

Int16: -32,768 - +32,767

Int32: -2,147,483,648 – +2,147,483,647

Int64: -9,223,372,036,854,775,808 - +9,223,372,036,854,775,807
 

[ovetteabejuela]

Then I think I could agree specially that I haven't read that there is such Data Types for Power Query. Thank you!