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
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

Could you explain more about your expected output?For example:200000 should be what for singapore?Maybe you may set the data type to text and then use 'replace value' to replace the 5 additional zeroes to other text.

Regards,

Cherie

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