Forum Discussion
Power Query/Power BI Problem with Decimals
It's very odd. I've: 1. Imported an xlsx file into Power Query 2. Did a bunch of transformations 3. Applied changes to carry over to Power BI Some decimals get messed up! An Example: 2.01 be...
Hi,
I have the same problem with MS Power Query.
I have an Excel file connected to a MS Access database.
I tried first with MS Query and a 1.8 value in Access become 1,799999952 in Excel (and same in MS Query).
So I tried with Power Query and it's the same result !
to complete my previous message: adding the round function doesn't change anything
to solve the problem, I changed the fields in the Access table to text format...