Forum Discussion

RichardTam's avatar
RichardTam
Helper I
4 years ago

Merge table created an error row

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

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      RichardTam
      Helper I
      4 years ago

      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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.