Number interpretation error after updating tables in PowerBi

Hi Syndicate_Admin , Thank you for reaching out to the Microsoft Community Forum.

I don’t think this isn’t a Power Query conversion problem at all. The decimals are already gone before Power BI even starts applying your steps. In the Source preview your values are integers, which means Power BI is receiving the data from Oracle after something upstream has already stripped or rounded the decimals. Once that happens at the source, no locale setting in Power Query can recover them.

When you connect to Oracle, open the Advanced options -> SQL statement box and write a query that forces Oracle to send the discount as text with a known decimal separator. Then in Power Query, convert that text to a decimal using Change Type -> Using Locale. This bypasses the driver and locale issues that are dropping the decimals and it guarantees that Power BI receives the exact numeric format you want on every refresh.