Forum Discussion
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 appending two tables, there shouldn't
has such limitatioion. Anyone could share some light what might go wrong?
Ellian
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?
10 Replies
What is your data source type?
While this is probably a bug with the way the data source does combine, it is probably caused by a different casing between the two columns.
The data source is data flow. It actually was acting fine but one day the dataset for the report refresh failed and has the error. If I removed the columns throw out the erros, it will just show the next column giving the errors
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?
it seems the error comes from those two tables
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.
