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 ...
I am on version 2503, build 18623.20178 64 bit
Edit: even after creating a blank workbook file and creating a new query, PQ still only picks up 4 decimal places when data is in the accounting format, and PQ is attempting to change the data type to Decimal Number
Do you work with .xls or .xlsx files? For them are different behaviour. If .xlsx I have no idea why so.
I am seeing this issue in both .xlsx and .xlsm file types
The issue occurs in .xlsx and .xlsm file types