SAP BW Import - Format of Numeric Fields Issue

[Anonymous]

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?

[v-jiascu-msft · Accepted 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

[Anonymous]

Thx...great info...I will pass on to IT.

[niroshinip]

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

[Anonymous]

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.

[niroshinip]

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

[SivaMani]

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]

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