Forum Discussion
Space in number type when imported from Sharepoint List
I partially fixed the issue. It all started when an IT admin changed the regional settings for the sharepoint Site. Consequently, I modified the same for my PowerBI files in settings. If it now works for currency, it still can't recognize the space separator in numbers (local fr-FR). The only solution was to remove separators in the sharepoint list view.
Memorable MemberI've just struck the same issue against a SharePoint site set to French. A viable workaround seems to be to revert to the 1.0 Implementation in the Source step. This correctly presents the numeric values (without space as a thousands separator).
Unfortunately, that takes you back to the old functionality: including all columns and mangling the column names somewhat. Both of those can be resolved fairly easily in the Query Editor (Choose Columns and Rename Columns steps).