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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.

  • llorenmillerr's avatar
    llorenmillerr
    Frequent Visitor
    6 years ago

    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.

    • WALEED's avatar
      WALEED
      Advocate II
      6 years ago

      Spot on. I've unmarked my workaround as a solution.

      • llorenmillerr's avatar
        llorenmillerr
        Frequent Visitor
        6 years ago

        Appreciate it, WALEED!

        Hopefully this will reopen the issue and someone will notice

         

        Best,

         

        LM