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...
This "solution" really isn't a solution. I've got the same problem with my decimal values playing all kinds of stupid, but the source document is owned by a customer and cannot simply be saved as a CSV because it's just one part of a vast spreadsheet that includes macros, etc.
Is there an official "fix" for this? Power BI and Excel are supposed to work seamlessly together, but that doesn't seem to include carrying over decimal numbers from Excel.
Incredibly dissapointed to see there is no reply to this over a year later.
Not even a Microsoft employee to check in and let us know this is a known issue or direct us to any other threads with similar issues?
And work arounds should not be marked as solutions.