Issue with thousands separator when importing from Business Warehouse

[Samboko]

When I import a dataset from a query in Business Warehouse, the measure, in this case the number of households, comes in with any thousands separator showing as a decimal (instead of a comma). So for example if I have a community with 600 households it will import as 600, but if I have a community of 10 200 households it imports as 10.200. It doesn't seem to matter what type of data type I use, and I've tried different measures from other queries with similar results. Any ideas? Below is some sample data that I pull into excel vs. Power BI.

                       

[v-haibl-msft · Accepted solution]

@Samboko

Please refer to the troubleshooting section of this document.

Numeric data from SAP BW returns decimal points instead of commas. For example, 1,000,000 is returned as 1.000.000.

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.

Best Regards,
Herbert