The column 'Date' of the table wasn't found.

[MeaningfulUser]

The infamous error of missing column still keeps bugging me.

I'm using Supermetrics API to pull data from Adobe Analytics 2.0 to Power BI desktop.

I change nothing in power query, just leave everything as it is.

A day passes and when I try refreshing data, I get the error saying The column 'Date' of the table wasn't found.

The same might happen to Clicks, or whatever.

I keep checking the steps in query editor, yet everything is there.

[MeaningfulUser]

This sort of error is very common for me.

I import data, and change absolutely nothing, then refresh data a few days later, and this happens (indicating that for example 'Date' of the table wasnt found), and when opening query editor:

Yes, the Navigation step used to have column names such as Dates, Clicks and so on, but now it has changed. Any ideas?

[v-juanli-msft]

Hi @MeaningfulUser 

Check if the data source change some columns' name, so the columns' headers are different with these in Power BI.

You could refer to similar threads below:

https://community.powerbi.com/t5/Desktop/Expression-Error-The-column-of-the-table-wasn-t-found/td-p/...

https://community.powerbi.com/t5/Desktop/The-column-quot-of-the-table-wasn-t-found/td-p/414717

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.