Number data type transfer is rounding off the number within range.

[dataplatform]

We have a number field which is transferred to number datatype using 

ChangedNumberTypes = Table.TransformColumnTypes(ChangedDateTypes,{ {"CIF_number_01", type number}, {"CIF_number_02", type number}, {"CIF_number_03", type number}, {"CIF_number_04", type number}, {"CIF_number_05", type number}, {"CIF_number_06", type number}, {"CIF_number_07", type number}, {"CIF_number_08", type number}, {"CIF_number_09", type number}, {"CIF_number_10", type number}...})

Here when value is passed to one of the column as `10155495739930353`, its getting round off to `10155495739930350`

In powerBI knowledgebase, we have checked number data type range which looks within the limit.

We would like to understand this conversion and would like to know if we can fix this.

[v-yetao1-msft]

Hi @dataplatform 

The Power BI Desktop data model supports 64-bit integer values, but due to JavaScript limitations, the largest number Power BI visuals can safely express is 9,007,199,254,740,991 (2^53-1). If your data model has larger numbers, you can reduce their size through calculations before you add them to visuals.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types#whole-number

Best Regards,
Community Support Team _ Ailsa Tao