Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

SAP BW Import - Format of Numeric Fields Issue

I am having an issue properly importing sales from a SAP BW connection.  As shown below, when the Actual Pounds are being pulled in, most results appear with multiple decimal points.  This occurs in ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi Anonymous,

     

    There is a solution in this official documentation: powerbi-desktop-sap-bw-connector. Please reference it for details. I quote the solution here:

    >>>To solve this error, users must ask their SAP admin to grant the SAPBW user being used in Power BI the right to execute BAPI_USER_GET_DETAIL. It’s also worth verifying that the user has the required DCPFM value, as described earlier in this troubleshooting solution.

    And other reference about restrictions: powerbi-desktop-directquery-sap-bw.

     

    Best Regards!

    Dale

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Hi   Anonymous,

No need worry. You have an option to change the data type in Power BI query editor. You will either convert it to the whole number or decimal number.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    It actually errors out because of the figures with the multiple decimal points.