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...
Temporary workaround; Save the XLSX as CSV and open in Power Query as Text!, Opening as CSV doesn't make the problem go away. This takes much longer to refresh in Power BI which is odd because it's super fast in Power Query.
I think part of the issue is that opening Excel/CSV files initially sets columns as (ABC/123) then I have to change all columns to (ABC) with whatever damage that's happened getting carried over.
Opening a CSV file as a Text File imports all the columns as text (ABC) from the very beginning.
It should work fine importing decimals as is. It sounds like a bug now.
WALEED sorry been away, did you get sorted?