Unexpected mashup error when changing type from DateTime to DateTimeZone in Power Query

[DanaG]

Hi, 

I importing data from a Postgres DB.Dates

In Power Query when trying to change the type of the date coloumn from DateTime to DateTimeZone - I get the following unexpected error:

Any suggestion as to how I might be ablet to fix it?

Thanks

[DanaG]

@Jimmy801- thank you so much - that solved my problem.

[Jimmy801 · Accepted solution]

Hello @DanaG 

try to surround your prior step with Table.Buffer

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy