Locale settings not working?

Hi jcapezzuto,

I am not able to reproduce your issue. Could you please share sample data of your scenario and post the output in Power BI Desktop? 

Based on my test, after I change global regional setting to Portuguese (Brazil)  in Power BI Desktop and import data from a sample text file, everything works as expected. For more details, you can check the following screenshots.






From the above figures, you can note that Power BI Desktop interprets the value “100,002” as a decimal number using a Portuguese (Brazil) format, and the date value “2/3/2016”  is interpreted as “3/2/2016” in Query Editor and “Wednesday, March,2016” in Data View. Furthermore, you can change the date formats to other existing formats in Data View, if you need to change it to DD/MM/YYYY format, you will need to use Format function.

For more details about how Locale Setting works in Power BI Desktop, you can review this simialr blog: https://blog.crossjoin.co.uk/2015/05/25/working-with-international-date-and-number-formats-in-power-query/ .


Thanks,
Lydia Zhang