Data imported with another time

[Anonymous]

I have a dataset with a datetime field in UTC hour but when I import the data with power query, it automatically changes the hour to my local time without me putting it in the script.

Can anyone help me understand how power bi handles timezones? 

Thank you!

[Icey]

Hi @Anonymous ,

Can the methods above solve your problem?

Best Regards,

Icey

[amitchandak]

@Anonymous , check

https://www.youtube.com/watch?v=M1zquwmpnZE

[Anonymous]

If you go on to power query, delete the "change type" step, right-click on the column and select 

Change type > Use Locale

Now you can select the correct region.