Rounding up issue when importing data

[milkynight]

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!

[Mama]

Hi. Did you get teh solution? Because i faced the same problem.

[v-easonf-msft]

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 _ Eason

[Anonymous]

Little count of context, But is your excel data in table format ?

[milkynight]

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]

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

[milkynight]

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

[v-easonf-msft · Accepted solution]

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]

Thank you this solved the issue for me as well

[amitchandak]

@milkynight , please open power query and check, Data type should be decimal not fixed decimal or whole number.