I got a problem in power bi where my dates in the csv file is changed when I imported the csv file

ty_34 — Wed, 07 Feb 2024 23:41:03 GMT

I got a problem in power bi where my dates in the csv file is changed when I imported the csv file into power bi

csv data date:

while importing to csv:

Re: I got a problem in power bi where my dates in the csv file is changed when I imported the csv file

Anonymous — Thu, 08 Feb 2024 06:25:40 GMT

I suggest you to change your [time_hour] column data type as "Date/Time/Timezone" instead of "Date/Time"

I can reproduce your issue with "Date/Time" data type.

It will be correct if I use "Date/Time/Timezone".

Best Regards,
Rico Zhou

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