Forum Discussion

milkynight's avatar
milkynight
Helper I
4 years ago
Solved

Rounding up issue when importing data

Hi guys,   Seeking your help to solve this problem. I have a data set in Excel format which I update monthly and refresh Power BI report to fetch data. Other months were fine, but starting from Sep...
Need Help
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, milkynight 

    Can you share relevant screenshots about the 'Applied Steps'?

    Have you checked the column data in the step of 'Navigation'?

     

    I suspect that your data has lost accuracy in step 'changed Type'. When you export data, please consider deleting the existing original steps 'Changed type' and then change the data type in step 'Navigation' again to build your own step 'Changed Type'.

     

    Best Regards,
    Community Support Team _ Eason

milkynight's avatar
milkynight
Helper I
4 years ago

 

Yes Data type is Decimal as seen in below screenshot. But you can see that Sep, Oct and Nov are imported without decimal compared to previous months... 😞

 

 

Teby's avatar
Teby
New Member
4 years ago

Hi.. did you find a solution to this. I am experiencing the same issue.:(

 

  • milkynight's avatar
    milkynight
    Helper I
    4 years ago

    Teby No i haven't found a solution to this yet...

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      4 years ago

      Hi, milkynight 

      Can you share relevant screenshots about the 'Applied Steps'?

      Have you checked the column data in the step of 'Navigation'?

       

      I suspect that your data has lost accuracy in step 'changed Type'. When you export data, please consider deleting the existing original steps 'Changed type' and then change the data type in step 'Navigation' again to build your own step 'Changed Type'.

       

      Best Regards,
      Community Support Team _ Eason

      • Elcin_7's avatar
        Elcin_7
        Helper I
        1 year ago

        Thank you this solved the issue for me as well