Forum Discussion
Power Query Dropping Decimals with Accounting Format
That is what's happening, but it doesn't make sense. If it is an intended feature, it's an incredibly poor choice on Microsoft's part.
If the source is xml-based file (.xlsx, .xlsm) Power Query takes data from xml structure and grid format shall not affect the result. If the source is binary file (.xls) Power Query takes values from the grid as texts, thus as many digits as format displays.
What's wrong in your case it's hard to say without playing with files. In any case that's not default behaviour if you work with xml-based sources. I'd try to recreate Power Query from scratch to check how it works.
The issue occurs not only in this long-standing excel file but also in blank/new excel files - creating a table from scratch with numbers formatted as accounting still results in Power Query only picking up 4 decimal places
If you open attached file and refresh the query, what is shows in your environment?