Forum Discussion
PS_78
2 years agoHelper II
Rounding Issue while accessing INFO CUBE using connector SAP Business Warehouse Application Server
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 s...
amitchandak
2 years agoSuper User
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
2 years agoFrequent Visitor
Hello amitchandak - No it's not a whole number. It's decimal as can be seen in the screen shot.
Thanks,
Phani