Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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
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
Change the type to "Text" and you'll see the full key instead of the 3.4E+19
You can do some transformations in Power Query. Just have to mess around with it, but the UI for Power Query is pretty slick
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |