Expression error: the field 'xx' already exist in the record

[pbidaxlearner]

Hi Experts,

I'm getting below error,when I try to append tables as new,since 2 days getting this error earlier it was working fine. And I have xx column in 2 base tables.

Expression error: the field 'xx' already exist in the record

Details: xx

Value = 

Please help me to resolve

@amitchandak,  @Ritaf1983, @Greg_Deckler 

[v-stephen-msft · Accepted solution]

Hi @pbidaxlearner ,

This error is usually caused by duplicate column names in the source data. In Power Query, each column must have a unique name. This error occurs if you try to add a column name that already exists. The solution to this problem is to change the column names or remove the duplicate columns.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.