Forum Discussion

FrancescoSCP's avatar
FrancescoSCP
Icon for Helper IV rankHelper IV
3 years ago
Solved

Wrong decimals from Excel data

Hi all,   i am having trouble reading data from excel file. Here the data in the excel: Value column is formatted as a number: When i load that data to Power BI, i set off aggregatio...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi FrancescoSCP ,

     

    Because Javascript: Number - JavaScript | MDN (mozilla.org)

     

    The max digits is 15-17 digits, depending on the actual numbers.

     

    This issue has been confirmed as an ICM , the ID is 340010831 . If there is any progress, I will come back and update .

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.