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

[MeaningfulUser]

Lately I've been gettin these errors constantly in different files.

They work fine for a week or two, and then some of them get errors, such as:

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

This can happen to Dates, Clicks, or even Campaign Name.

I tried finding the error in Power Query Editor by going back the applied steps, but I see that the name hasn't been changed or anything. 

[v-eachen-msft]

Hi @MeaningfulUser ,

It seems that "Clicks" column has been removed or renamed. You could use the new column name in the query editor.

[MeaningfulUser]

Thanks,

It hasn't been renamed on removed. For example, I imported a table and left it untouched. A day later when refreshing, I get the same error, saying that Dates are missing.

When I go to applied steps, Navigation, I see this:

I didn't change the name of the table or the name of the columns and such

[rajulshah]

Hello @MeaningfulUser,

Can you check if the column exist in the source or not?

[MeaningfulUser]

Hey @rajulshah 

I'm using a Web source to create a table, so I'm only seeing code, and the tables: Caption, Source, ClassName, Id, and Data

[rajulshah]

Can you please provide the file?