Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Anonymous
Not applicable

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

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

 

Excel Data: Filed(Data type: Number)

Excel_values.jpg

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

Power_Query Values.jpg

 Please, help me to resolve this issue.

 

 

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

Rounding is present in this step.

vluwangmsft_0-1649924078577.png

 

Refer the following output:

vluwangmsft_1-1649924169042.png

 

vluwangmsft_2-1649924227471.png

 

And you could  choose the below one:

vluwangmsft_3-1649924601071.png

After change to this ,when you import:

vluwangmsft_4-1649924650371.png

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


Best Regards

Lucien

View solution in original post

4 REPLIES 4
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

Rounding is present in this step.

vluwangmsft_0-1649924078577.png

 

Refer the following output:

vluwangmsft_1-1649924169042.png

 

vluwangmsft_2-1649924227471.png

 

And you could  choose the below one:

vluwangmsft_3-1649924601071.png

After change to this ,when you import:

vluwangmsft_4-1649924650371.png

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


Best Regards

Lucien

HotChilli
Super User
Super User

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

 {"O", Int64.Type},

 

HotChilli
Super User
Super User

can you post the Advanced Editor code please?

Anonymous
Not applicable

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"

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.