Forum Discussion

WALEED's avatar
WALEED
Advocate II
8 years ago

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...
Need Help
WALEED's avatar
WALEED
Advocate II
8 years ago

vanessafvg zoloturu

 

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.

vanessafvg's avatar
vanessafvg
Community Champion
8 years ago

WALEED sorry been away, did you get sorted?

  • WALEED's avatar
    WALEED
    Advocate II
    8 years ago

    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.