Forum Discussion

DmitryKo's avatar
DmitryKo
Icon for Helper IV rankHelper IV
3 years ago

Power BI Rounds Int64 columns to next thousand

Simple table with EmployeeID column that has underlying Int64 data type. Source is import from Excel if it matters. Problem: the model rounds the data value to the closest thousand. This is how it...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

DmitryKo You could try decimal number. You really want that as Text though. Using ID's like that as a number tends to remove leading zeros, etc. I highly recommend you leave it as Text.

  • DmitryKo's avatar
    DmitryKo
    Icon for Helper IV rankHelper IV
    3 years ago

    The id in the datasource is int64, so leading zeroes are not an issue - if the data is interpreted correctly. Quesion is: why it's not being interpreted correctly by power bi (power query engine)?

    And no, I don't want it as text; my assumption is performance on int64-based key vs text-based key would be orders of magnitude different.

    P.S. Are you seriously suggesting changing ID column to a floating point data type?..
    P.P.S. Please fix your signature, your 2 rows of text long reply takes almost entire screen due to clutter in the sig.