Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ovetteabejuela
Impactful Individual
Impactful Individual

Only 64-Bit Data Type in Data Models?

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.

 

8Bit.PNG

1 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
 

Specializing in Power Query Formula Language (M)

View solution in original post

4 REPLIES 4
MarcelBeug
Community Champion
Community Champion

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.

Specializing in Power Query Formula Language (M)

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).

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
 

Specializing in Power Query Formula Language (M)

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.