Forum Discussion

PS_78's avatar
PS_78
Helper II
2 years ago

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 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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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's avatar
      PSivapuram
      Frequent Visitor
      2 years ago

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

       

       Thanks,

      Phani