Forum Discussion
WALEED
8 years agoAdvocate II
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...
vanessafvg
8 years agoCommunity Champion
WALEED sorry been away, did you get sorted?
WALEED
8 years agoAdvocate II
It's a weird problem.
I've saved the worksheet as a CSV and the problem didn't go away.
I've saved the worksheet as a CSV, imported as a TEXT file and the problem was solved.
Kudos to you for troubleshooting with me.