PowerQuery is bringing in Whole Numbers not Decimal Places?

[wherdzik]

Why is this happening, I am bringing in a bunch of workbooks in from a specific sheet. In this case the case in the screen shot below, toward the bottom there is a split of 0.80 clinical and 0.20 program director. 

BUT when I try to bring it in even though I set the column type as decimal this split is not coming in? Why is this happening?

I don't get it.  Can someone help me please?

[wherdzik]

I am bringing in by excel powerquery by the way.  What I did was changed it to a text value and it brought in the decimals..not sure why this happend but it works now.

[AbhinavJoshi · Accepted solution]

Hello @wherdzik . When you import the data, I would suggest checking the changed type step in power query. Usually it is the second or third step. Check what conversion is happening in that step. Once power query has converted a decimal to whole number, and you try to convert it to a decimal number back, you'd loose your decimal values. I would also suggest checking the data load options. 

I hope it helps. 

Best,

Abhinav