Forum Discussion

DanaG's avatar
DanaG
New Member
5 years ago
Solved

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

 

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

 

 

 

 

 

 

 

Need Help
  • Jimmy801's avatar
    Jimmy801
    5 years ago

    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

2 Replies

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    5 years ago

    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