Forum Discussion

Nosh10's avatar
Nosh10
Helper II
6 years ago
Solved

Integer not Converting to Decimal

Hello,    I have a file, and one of the columns has decimal points. However, Power BI uploaded the column as a whole number. I changed the column in the data tab to reflect a decimal number, bu...
Need Help
  • Nosh10's avatar
    Nosh10
    6 years ago

    I solved the issue. I needed to update the data in the advanced editor. 

camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Nosh10 ,

 

Check on Query Editor the steps converting data types, perhaps it's converting there. If yes, just change the type.

Nosh10's avatar
Nosh10
Helper II
6 years ago

Hi! Thanks. I changed the data type in the query editor as well, and no luck. Can you provide any work arounds?

  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    Hi Nosh10 ,

     

    Can you share the pbix ? If no, take a print of Query Editor, to check the applied steps.

    • Nosh10's avatar
      Nosh10
      Helper II
      6 years ago

      Please see below for view of query editor

      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        Nosh10 , Right-Click on the table, you will see Advanced Editor option. You will see a text like this

         

        let
        Source = Excel.Workbook(File.Contents("...bi\decimal.xlsx"), null, true),
        Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
        #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
        #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Number", type number}, {"Number1", type number}, {"Name", type text}})
        in
        #"Changed Type"

         

        You will see {"Order No", Int64.Type} replace with that {"Order No", type number},