Forum Discussion
Power Query Dropping Decimals with Accounting Format
I'm encountering what seems like a bug in Power Query. I have a table with data that contains numbers with more than 4 decimal places. When this data is in the Accounting format, Power Query is only ...
When you change the type to Decimal Number, you’re right in thinking that should ideally allow for more decimal places. However, when you’re dealing with cells formatted as Accounting, Power Query might still regard them as having the limitations of that format.
It seems like that is the case. It is possible I've missed this happening previously, as I only caught it when implementing a check on data accuracy without rounding, but it does seem problematic for business applications that rely on data accuracy, such as my role. To me, this seems like more of a bug than intended feature.
