How do I fix: "Expression.Error: The column 'DisplayName' of the table wasn't found"

[Chasman]

I get the message: "Expression.Error: The column 'DisplayName' of the table wasn't found" when trying to connect Power BI to my online MS list:

The column "DisplayName" doesn't exist in my list, so in an attempt to solve the problem, I created a new column with that exact name, but it did not help.

When I try to load anyway, I get this message: 

Any suggestions to how do I overcome this?

Thanks in advance 🙂

/C.

[Anonymous · Accepted solution]

HI @Chasman,

AFAIK, power query will cache the table structures into the query steps, and they not auto synced when data source changes.  Normally this issue appears when the data source table updated or manually modify cached structures in previous query steps.

For this scenario, you need to check these query steps and cached structures to manually fixed not matched fields to help power bi mapping new records structures.

Regards,

Xiaoxin Sheng