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?

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.

KNP's avatar
KNP
Super User
3 years ago

It did work.

The Datasource is Dataflows using the PowerPlatform.Dataflows() connector in my case.

I wasted 3 hours thinking I was doing something wrong, so was glad to find this post. 

Would love to know what has changed and whether this will potentially break existing Datasets.

 

  • artemus's avatar
    artemus
    Microsoft Employee
    3 years ago

    I would also like to know, but haven't been able to reporduce this problem.