Forum Discussion
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 all fields inputted, like Net Sales, Gross Sales, Open Orders, etc. What can be causing this and is there a solution?
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
7 Replies
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.
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
Hi,
Did this resolve your issue? We also have the same issue and we gave the authorzation for this BAPI but still the decimal notation problem is there. But for users with full admin rights in SAP BW the notation is ok. The default values for both users are same.
Is there any other authorization to be given?
Regards,
Niroshini
