How to get the exact decimal values from Excel to power bi

[Anonymous]

I wanna bring my decimal values as it is to powe bi. 

Excel Data: Filed(Data type: Number)

In Power Query: I selected the data type as decimal number. but, still it's rounding the values. 

 Please, help me to resolve this issue.

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

Rounding is present in this step.

Refer the following output:

And you could  choose the below one:

After change to this ,when you import:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[HotChilli]

If you edit the code, you can remove this part from the #"Changed Type" line

 {"O", Int64.Type},

[HotChilli]

can you post the Advanced Editor code please?

[Anonymous]

let
Source = Excel.Workbook(File.Contents("C:\Users\ANAMALA RAGHU\Desktop\Pravalika Assignments\PK vs CSK (1).xlsx"), null, true),
Bowler_Sheet = Source{[Item="Bowler",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Bowler_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Player", type text}, {"Team", type text}, {"O", Int64.Type}, {"M", Int64.Type}, {"R", Int64.Type}, {"W", Int64.Type}, {"NB", Int64.Type}, {"WD", Int64.Type}, {"Column9", type any}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column9"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns",{{"O", type number}})
in
#"Changed Type1"