Forum Discussion

rickidela's avatar
rickidela
Regular Visitor
6 years ago
Solved

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!!!