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?

KNP's avatar
KNP
Super User
3 years ago

Hi artemus,

 

I've stumbled across this while trying to solve this very issue.

I was doing a very simple Table.Combine() with two Dataflows and it was throwing an error that made no sense.

 

Can you explain this solution and what has changed to cause this to be needed?

Do I need to go and check other Datasets that have this Table.Combine() logic?

 

Thanks.

artemus's avatar
artemus
Microsoft Employee
3 years ago

If this works it indicates there is a bug in the datasource folding implementation (or less likely the power query engine). This funcation forcable breaks folding and as a result works around the bug.