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

niroshinip's avatar
niroshinip
New Member
8 years ago

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

 

niroshinip's avatar
niroshinip
New Member
8 years ago

Now its working. Think clearing the cache resolved the issue.