Forum Discussion
Excel is adding extra digits behind the scenes for a report
I have an excel report that I am using as a data source for Power BI. In the excel report it is showing the project numbers as 31900004.001 but when pulling into power bi they're showing as 3190004.00999998 which is creating issues since I am trying to relate this table to other tables based on the project number. I have already tried the power BI forum and someone took a look at the data and stated the issue is in excel. Can you please help?
13 Replies
dailyjm The project numbers you see in Excel seem to be real numbers with many decimals, but formatted to show only three decimals. If you need to pull these into Power BI as numbers with exactly three decimals, you could round them in Excel first. But you can also do the rounding in Power BI by transforming the numbers column to numbers rounded to three decimals.
- Why can't I see them in excel even after formatting as text? Unfortunately I cannot just round as some projects may have 2 decimal places and some 3 and some of these extra numbers should even be showing as no decimal places.
dailyjm Don't really follow. Where do the project numbers come from to begin with?
Can you upload a screenshot showing the number with e.g. three decimals and what's included in the formula bar. For example like this:
