Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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"
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
97 | |
88 | |
70 |
User | Count |
---|---|
165 | |
131 | |
129 | |
102 | |
98 |