Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

undefined

PowerBI is rounding my data up in the report which is affecting my final result when I do my caluclations and I would be glad if anyone could help with this challenge. for example the raw data is 228.09879400 but when the data get imported into Powerbi desktop, its rounded up to 228 for all the data in those columns .

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    In the model view, there is option to change the number decimal place.  Can you change the decimal place and check, is ti still giving rounded value,

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi moeconsult ,

     

    After importing the data go to Home-->Edit Queries -->EditQueries-->Home-->Data Type

    I hope this helped you

     

    Regards,

    Husna

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I did that already but it is not making any difference 

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        Hi Anonymous ,

        Can you please share more details to us?

        • What data source do you connect?
        • What the data type is in your data source?
        • What mode do you use? Direct Query or import?
        • What the version of Power BI Desktop do you use?

        Best Regards,

        Xue Ding

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