Forum Discussion
Solved
Mystery error when APPENDing query: “The field 'Field4' already exists in the record.”
Hello all, I’m stuck on an error/circumstance I’ve not run into before. When attempting to APPEND Query2 to Query1 . . . . . . an error is generated: “Error: Expression.Error: The field...
We found a solution for the error. The answer is wrapping offending APPEND queries with Table.StopFolding().
Table.StopFolding - PowerQuery M | Microsoft Learn
JonasArnout2
Advocate I
Advocate IThx, very strange error indeed.
We encountered this error after moving some queries to dataflows, which is a non foldable source... but then again all appended tables are sourced from dataflow