Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to 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
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
If you edit the code, you can remove this part from the #"Changed Type" line
{"O", Int64.Type},
can you post the Advanced Editor code please?
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"
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
76 | |
74 | |
55 | |
45 |
User | Count |
---|---|
117 | |
106 | |
77 | |
66 | |
65 |