Wrong regional format in numbers from SharePoint list

[Anonymous]

I have a SharePoint list that uses a number format with '.' as a thousands separator and ',' for decimals.

When I try to connect to the data in PBI, these are reversed and 1.000,00 is imported as 1.00

Turning off the thoursands speparator for the column in the SharePoint list fixes this, but I really want to have it turned on for readability.

The file is using the correct regional settings.

[Syndicate_Admin]

Hello.

I solved it as follows:

1.- Sharepoint

2.- I choose my place

3.- Documents

4.- Gear of the upper right (Configuration)

5.- In the menu choose Site Contents.

6.- It takes us to a page where the contents and the Subsites are. Above those options another menu appears, and there is SITE SETTINGS. Enters.

7.- In the Site Administration section REGIONAL CONFIGURATION appears.

8.- In my case I changed Schedule, Regional Configuration, Ordering Criteria and that's it.

I hope someone finds it helpful.

[Syndicate_Admin]

Hi, I have the same problem in Sharepoint List, it puts me thousands separator (.) Were they able to figure it out?

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

This blog has helped me solve similar problems. I hope it can also help you:

https://eriksvensen.wordpress.com/2018/07/02/powerquery-how-to-handle-different-decimal-separator-when-importing-csv-files/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@amitchandak 

Yes, regional settings for the file are correct.

If I change the column format to text, it's still wrong.

It's like it's pulling incorrect data.

[amitchandak]

@Anonymous , Power bi using the correct European region country in the regional setting?

like this

https://community.powerbi.com/t5/Desktop/Thousand-Separator-and-Decimal-Separator/m-p/194928