Forum Discussion
Dates modifies when updating
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!!!
Refer to this post
Check or change the locale settings..
If it helps, mark it as a solution
Kudos are nice too
1 Reply
- VasTgMemorable Member
Refer to this post
Check or change the locale settings..
If it helps, mark it as a solution
Kudos are nice too