Forum Discussion
Cannot covert a 9.99e+11 value to integer
I've imported key integer field from a SQL database and the value is 999000024011. The Grid is showing the imported value as 9.99e+11 in this as well as the subsequent fields. The susequent fields ho...
Hey RandyB.
You are working in PBI Desktop correct?
I am unable to replicate the issue. I added a "key" column that is 11 numbers long to my sql server and imported into PBI Desktop and if I make the data type "Whole Number" then it shows the field just fine in all my visuals. Can you provide a screenshot of your data or some similiar sample data so we can get a better idea of the problem?
Thanks,
Alan
Thanks Alan. It is in PowerBI for Desktop. I also have it set as a whole number. You can see from the above, the DOC_ID field is the culprit.
thank you.