Forum Discussion
SAP BW Import - Format of Numeric Fields Issue
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 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
Thx...great info...I will pass on to IT.
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
Now its working. Think clearing the cache resolved the issue.
We ended up with a strange situation that my supervisor was able to pull in the data into Power BI without the multiple decimal points whereas nobody else could. In the end our IT department figued out it was an SAP role issue. They made adjustments to the roles of the non-supervisorial staff and the decimal point issue went away.
