Forum Discussion
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, there was missing data due to decimal points.
Double-checking my Excel data, there was no round-up. Hence I'm uncertain why Power BI doesn't accept decimal and auto round-up numbers? How can I fix this to have the exact numbers as my Excel data?
Thanks much for your help!
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
9 Replies
milkynight , please open power query and check, Data type should be decimal not fixed decimal or whole number.
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... 😞
Hi.. did you find a solution to this. I am experiencing the same issue.:(
Teby No i haven't found a solution to this yet...
Hi, milkynight
Can you tell me if your problem is solved?
If you still need help, please share more information about it.
Best Regards,
Community Support Team _ EasonHi. Did you get teh solution? Because i faced the same problem.
