Large Keys not being Uniquely Identified

[alafrenz]

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!

[ssugar · Accepted solution]

Change the type to "Text" and you'll see the full key instead of the 3.4E+19

[v-yuta-msft · Accepted solution]

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

[ssugar · Accepted solution]

Change the type to "Text" and you'll see the full key instead of the 3.4E+19

[Anonymous]

You can do some transformations in Power Query.  Just have to mess around with it, but the UI for Power Query is pretty slick