cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
alafrenz New Member
New Member

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 Smiley Sad

 

Thanks for your time!

2 ACCEPTED SOLUTIONS

Accepted Solutions
ssugar Member
Member

Re: Large Keys not being Uniquely Identified

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

Community Support Team
Community Support Team

Re: Large Keys not being Uniquely Identified

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.

Capture.PNG 

 

Regards,

Jimmy Tao

3 REPLIES 3
Nick_M New Contributor
New Contributor

Re: Large Keys not being Uniquely Identified

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

ssugar Member
Member

Re: Large Keys not being Uniquely Identified

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

Community Support Team
Community Support Team

Re: Large Keys not being Uniquely Identified

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.

Capture.PNG 

 

Regards,

Jimmy Tao