Forum Discussion

pierre415's avatar
pierre415
Helper I
9 years ago
Solved

Prevent Scientific Notation

I'm dealing with some ID numbers that show up fine in Excel but get converted to Scientific Notation whenever I import them in PBI, which also changes the numbers for some reason. Is there any way to...
Need Help
  • pierre415's avatar
    pierre415
    9 years ago

    Just started working actually, I added a * to the column in excel and then removed it in PBI!

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

I'd like to play around with that, how big does the number have to be in Excel?

  • pierre415's avatar
    pierre415
    Helper I
    9 years ago

    Just started working actually, I added a * to the column in excel and then removed it in PBI!

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Community Support
      9 years ago

      pierre415,

       

      Glad to hear that you've solved this problem. You could help accept it as solution. Your contribution is highly appreciated.

      • CasperLehmann's avatar
        CasperLehmann
        Frequent Visitor
        8 years ago

        We have a similar problem. Some zeros in Tables and Matrices appear with scientific notation, dispite being set to Integer.

        We solved it by rounding to two decimals with ROUND([measure], 2), and then changing the format to 'Whole number' in the Modelling tab.