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
hi all , plesee notice on column Q I highlight
in excel I extracted from system . It doesn't show me the decimals , once I move my causer to on it . It is appear to have decimals 0.0416666 on it.
ehen import into BI , the decimals are all lost.
I lost around 1000 volume in 1 outlet.
I have 300 excel files in hand which causing the same.
Donu have any idea how to let BI know that this is the decimals even in excel show 0 decimals ?
Solved! Go to Solution.
@Chanleakna123 you can try changing the script from advance editor in power query
For your case you need to change the datasource to Type number highlighted in yellow
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍
@Anonymous @Anonymous , the column is set as "custom"
and this is original extracted from system. If I make change on this to number , I may need to change to another a hundred file . Which is taking time. Do u have any idea on this ?
@Chanleakna123 you can try changing the script from advance editor in power query
For your case you need to change the datasource to Type number highlighted in yellow
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍
@Anonymous @Anonymous All doesn't work . Seems like it show me 0.00000
@Chanleakna123 This happens when there is no proper formating of datatype applied in Excel ...Seems like the row "Q" has datatype "Numbers" which is why the decimal part is shown only in formula bar not in cell....
To make this work in power bi please change the field settings
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍
@Chanleakna123 - In power Bi after loading the data , you can set up the decimal places aftre going to Column Tools tab and then set the decimal places as highlighted below-
Hi , I tried , it doesn't work . It appear 0.00000
sth like this. Which is losing the real decimals number in excel
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 |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |