Date/Time is off by 2 hours when loaded to table

[talbot]

As you can see in the data preview, the time should be midnight, but when loaded to the table it is appearing as 2 hours earlier. Why is this happening?

[v-yanjiang-msft · Accepted solution]

Hi @talbot ,

I guess it may related to the time zone, please try to change time to local in power query as below.

Or please see if this blog can help: 

Handling Different Time Zones in Power BI / Power Query — The Power User

Best Regards,
Community Support Team _ kalyj

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