Data value exceeds the whole number(Int.64) datatype limit

[AishwariyaV]

Hi all,

I am currently working on a dataset in which a column contains data value as 9223372036854775807, but the power bi whole number datatype limit is from -9223372036854775807 to 9223372036854775806, so it throws error.

What is the solution for this?

Thanks in advance.

[V-pazhen-msft]

@AishwariyaV 

This idea may not be realized. According to the document, it allows for 19 digits; positive or negative whole numbers between -9,223,372,036,854,775,807 (-2^63+1) and 9,223,372,036,854,775,806 (2^63-2). This is the underlying design of power bi. If use Value() to forcibly convert it to an integer type, the following values will all be displayed as 0.

This is the relevant document, I hope to help you:

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

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[jdbuchanan71]

Can you change the data type to text?

[AishwariyaV]

hi @jdbuchanan71 ,

It works when i change to text datatype, but what if i wanna use it as such, as numeric value?