Forum Discussion

RandyB's avatar
RandyB
New Member
9 years ago

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...
Need Help
alanhodgson's avatar
alanhodgson
Icon for Solution Supplier rankSolution Supplier
9 years ago

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

 

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    9 years ago

    For the purpose of testing, can you change the column type to text in Query Data modelling.

    • RandyB's avatar
      RandyB
      New Member
      9 years ago

      Thanks Parry. It did change it to show the value but when I converted it back to a whole number, it converted it back to the exponential format. this will be a problem when I join the tables on the  fields. 

       

      That is a great suggestion. 

       

      Randy.

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        9 years ago

        Until someone provide what is the exact solution, can you change datatype to text in both tables and join on that, that will get you going.

  • RandyB's avatar
    RandyB
    New Member
    9 years ago

     

    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.