Numbers rounding problem in query

[CogitaHungary]

I have a query from another Excel file which includes numbers with decimals at the time of creation. If I make a refresh and the source file completes with other data, the new data will be rounded numbers.

[Anonymous · Accepted solution]

Hi @CogitaHungary ,

The Decimal number data type in Power BI can sometimes lead to rounding due to its handling of floating-point numbers, which store values as approximate data types. This approximation can result in precision loss, especially when new data is added during a refresh.

To minimize this problem, I suggest changing the data type of the columns to fixed decimal numbers. This data type has a fixed decimal separator position, and precision can be improved by customizing the number of digits to the right of the decimal separator, thus avoiding unnecessary rounding.

In the Power Query Editor, select the column you wish to change.
In the Transform tab, find the Data Type dropdown and select Fixed decimal number.
This action should help preserve the precision of your data when it's refreshed from the Excel source file.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CogitaHungary]

Dear Dino,

Thank you for the proposal. It looks solved my problem.