Forum Discussion

holidays511's avatar
holidays511
Frequent Visitor
2 years ago
Solved

dataflow datetime.from is returning weird results

Hey guys, i'm seeing some weird thing.  First thing first, my regional setting locale is English (United States)

 

When I do this function in Workspace Dataflow (power query), i get the expected output (see screenshot below)

 

 

but when i wrap the above function with another function like so.

 

The datetime seem to be automatically converted to my current local datetime (which is in New Zealand).

Now the thing is, this was not use to be like this.

It use to be just convert the datetimezone to datetime format without changing the zone.

 

 

Anyone know what happened here? or experience something similar?

 

Thanks.

1 Reply