Forum Discussion

wherdzik's avatar
wherdzik
Helper III
2 years ago
Solved

PowerQuery is bringing in Whole Numbers not Decimal Places?

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 pro...
Need Help
  • AbhinavJoshi's avatar
    AbhinavJoshi
    2 years ago

    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

AbhinavJoshi's avatar
AbhinavJoshi
Responsive Resident
2 years ago

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