Forum Discussion
Large Keys not being Uniquely Identified
I'm importinf from a database that uses large keys such as 34000000000000000002, 34000000000000000005, 34000000000000000007, etc. When I import into PowerBi, all of these keys are read as 3.4E+19 due to the size (I'm guessing). Is there anyway to combat this? Obviously, it makes doing anything that involves two tables rather difficult since all the keys are the same value :(
Thanks for your time!
Change the type to "Text" and you'll see the full key instead of the 3.4E+19
Hi alafrenz,
It's a built-in feature that large number will be transformed to scientific version, if you want to change to original version, you can change data type to text.
Regards,
Jimmy Tao
3 Replies
Change the type to "Text" and you'll see the full key instead of the 3.4E+19
Hi alafrenz,
It's a built-in feature that large number will be transformed to scientific version, if you want to change to original version, you can change data type to text.
Regards,
Jimmy Tao
