Share via

Power query keeps saying "Expression.Error The column " " of the table wasn't found. But that column exists in the source document.

Anonymous
2024-09-26T12:39:12+00:00

Hello,

Like the title says I'm having an issue with power query giving me the error that column "ENTITY" wasn't found in the source. However the column is in the source data, untouched. I tried editing it and it still did not work. Not sure what to do from here.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2024-09-26T13:37:44+00:00

    Power Query is case sensitive, so if the column header is "Entity" or contains an invisible char, e.g. a blank "ENTITY ", you'll get this error.

    Add the related steps after the source step to resolve this issue. (e.g. demote headers, transpose the table, convert the first column to uppercase etc., transpose the table, promote headers).

    Andreas.

    0 comments