Dates modifies when updating

[rickidela]

Hi all, im having a problem with the "Date" column when i update Deskopt Power Bi.

My database is from a Google Sheet linked with Typeform (A survey platform) in which i have a column with specified date and hour of each response, but when i import the sheet in powerbi, the column figures as "Text" and not "Date/Hour" (dd/mm/yyyy) format.

First, when i change the column format into "Date/Hour", its all ok. However, when i update the database, some dates modifies alone.

For example: A date that was 04/11/2020 (4th of November) changes to 11/04/2020 and the "Date/Hour" format still being dd/mm/yyyy.

Please help!!!

[VasTg · Accepted solution]

@rickidela 

Refer to this post

https://community.powerbi.com/t5/Desktop/FORMAT-changes-date-ignores-locale-bug-or-feature/td-p/4453...

Check or change the locale settings..

If it helps, mark it as a solution

Kudos are nice too