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 additional zeroes as show in the attached screenshot. But this works perfect for the users in India but doesn't work for users in Singapore. I have tried changing the regional settings in the tool but still failed to work. My business intelligence support team says that this is a tool level issue and they couldn't be of much help. Can someone please help? I couldn't do a work around by creating separate columns because there are few lines (very few), that are without these zeroes.

 

 

Need Help

6 Replies

  • 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