Rounding Issue while accessing INFO CUBE using connector SAP Business Warehouse Application Server

[PS_78]

Hello - I am accessing a standard CDS View, IMATDOCITEM from S4 into Power BI. I have an issue with Quantity. It is automatically rounding off the values in the very 1st step, "Added Items". Please see the screenshot below. For the last 3 lines in Power BI Query Editor, quantities should have been 0.650, 0.350 and 0.300. But they are rounded to 1, 0, 0. I tried rounding to 4 decimals. But that didn't help. Any help here would be great.

Thanks,

Phani

[amitchandak]

@PS_78 , Open Power Query and check the Change Data Type step to ensure the column has not become a whole number in any step. The first Change Type is important because once it becomes a whole number, changing it to decimal in a subsequent step will not help.

[PSivapuram]

Hello @amitchandak - No it's not a whole number. It's decimal as can be seen in the screen shot.

 Thanks,

Phani