Merge table created an error row

[RichardTam]

Refreshing a query i previously wrote with new data, i notice the expand table step causes an error:

An error occurred in the ‘’ query. Expression.Error: The column 'Matching ID' of the table wasn't found.
Details:
<Matching ID>

and i noticed the table under the merging column has the expected data and an extra error row at the bottom:

wonder how to remove the error row at the bottom, before expanding it

[Anonymous]

Hi @RichardTam ,

Please try to right click on your query then select Advanced editor. Here you can see the name of columns/object used for each step of your query, find the unfound column name and edit it.

Here's the similar post:

Expression.Error: The column '' of the table wasn'... - Microsoft Power BI Community

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.

[amitchandak]

@RichardTam , is matching ID is join column , or expanded, I doubt that is missing in dataset now

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[RichardTam]

it is the join column, which is the "Job ID" column
I have checked the table has no errors, so i have no idea how that error appear

would be fine if there is a way to remove the error row within the table,