Forum Discussion

EllianHs's avatar
EllianHs
Frequent Visitor
3 years ago
Solved

PowerBi Append two table with error message "Expression.Error: The field 'xxx' already exists

Hi    I started getting errors this week (3/13/2023) when processing append tables in power query. The message descrinbes there is a certain field has exist but from my understadning, when appendi...
Need Help
  • artemus's avatar
    artemus
    3 years ago

    Does adding Table.StopFolding(<<table>>) around both tables still result in an error?

    I.e.

    Table.Combine({Table.StopFolding(<<table>>), Table.StopFolding(<<table>>)})

     

    Also, what version of Power Bi (or Excel) are you using?

KGillett's avatar
KGillett
Frequent Visitor
1 year ago

I came across this error yesterday and couldn't make sense of it.  Very glad to find this post and thank the very clever people that work these things out.