Forum Discussion

bradbeliveau's avatar
bradbeliveau
Copper Contributor
Apr 11, 2025

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 ...
BI & Data Analysis
developer
excel
power bi
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 17, 2025

I can't reproduce that

On which Excel platform/version you are?

  • bradbeliveau's avatar
    bradbeliveau
    Copper Contributor
    Apr 17, 2025

    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

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 18, 2025

      Do you work with .xls or .xlsx files? For them are different behaviour. If .xlsx I have no idea why so.

      • bradbeliveau's avatar
        bradbeliveau
        Copper Contributor
        Apr 18, 2025

        I am seeing this issue in both .xlsx and .xlsm file types

Resources