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

[ty_34]

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:

[Anonymous · Accepted solution]

Hi @ty_34 ,

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.