Expression.Error: The column 'COMPANY' of the table wasn't found.

[admin11]

Hi All

When i refresh my PBI file , i get 8 error :-

when i click on View errors , i notice that below are the 8 error :-

When i want to delete the first Error in Sales (3) , the bracket (3) , mean that there are 3 error on Sales table , when i search for the 1st error , it said :-

Expression.Error: The column 'COMPANY' of the table wasn't found.

I delete it and found that my sales staff still working , I go ahead to search for 2nd error , the error very similar to above  

Expression.Error: The column 'Sal1_' of the table wasn't found.

Again i delete the error away , my table still working , then i go to 3th error :-

Now my first error dis-appear , i just like to know 

The first error on sales table :-

Expression.Error: The column 'COMPANY' of the table wasn't found.

Why this error appear ?

Hope some one can share with me.

Paul

[v-henryk-mstf · Accepted solution]

Hi @admin11 ,

In general, this error indicates that you have some step in your query that explicitly references the missing column by name.

I think you can check for errors in a different way: open the advanced editor on that query, copy and paste the entire query into a text editor and do a Find for the column name.

The following changes can be made in the statement as a sample:

let
    Source = Table.RemoveColumns(
    Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}),
)
in
    Source


let
    Source = Table.RemoveColumns(
    Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}),
    "Address",MissingField.Ignore
)
in
    Source

Fore more details, you can read related document link:

Table.RemoveColumns - PowerQuery M | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your feedback.

Best Regards,
Henry

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