Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Quantity appears different when connected from SAP server

Hello   I recently connected my Power BI desktop to SAP application server database and when data is pulled from it, the numerical data appears to be different; in the sense, it comes out with 5 ad...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello v-cherch-msft

 

Thanks a lot the response. The value of 200000 should come as 2. It comes as decimal from raw data, and when i change to whole number, it gets the zero added to it. The same process doesn't impact users in india. I am unable to convert to text as I use the numbers in the calculation. 

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

It seems you may try to set the Region of PC and Locale in desktop.

Regards,

Cherie

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-cherch-msft

     

    Dear Cherie,

     

    I have changed the location of my laptop as well as the regional settings in PowerBI but didn't seem to solve my issue. 

    Please see the attached screenshot after making the changes. Still unable to exactly figure out the issue. 

    • v-cherch-msft's avatar
      v-cherch-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous

       

      Please check if this article could help you.

       

      Regards,

      Cherie

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        v-cherch-msft

         

        Dear Cherie,

         

        I tried as given in the article. but it works for somelines and doesn't work for some of the lines. My data comes live from SAP database, so i am trying to log a call with Microsoft support too. I will inform you if I able to solve it. Thanks for you extended support.