A query connects to a SharePoint List in a site with Regional Settings set for French. Numeric values over 999 result in errors, seemingly because they are returned in French format with a space as the thousands delimiter eg 123 000.
If you set the Implementation to 1.0, the numeric fields are returned with accurate values and no errors, but often the field names are mangled.
The same List can be read by a Power BI Gen1 Dataflow using Implementation 2.0, which returns the numeric values correctly. That confirms there is a bug in Power BI Desktop.
However the Dataflow loses the detail for columns that are Table-type or List-type, e.g. SharePoint Lookup or List columns. I guess I could build 2 queries and Merge them on ID, or move all the downstream queries into the Dataflow, but all options seem quite clunky to maintain.
I've raised support case 2510310030000166 for this, hoping to get it acknowledged as a bug.
Also discussed on this reddit thread:
https://www.reddit.com/r/PowerBI/comments/1olluzc/sharepoint_list_in_a_site_set_to_french_numeric/
on:
REST API for removing all tags
nschachter
on:
Increase the REST API Limitation for tags
on:
Image upload in Power BI