Issue with Header Names in Power Query

Like (2) Share

Report

Posted on 16 Aug 2023 21:45:18 by Phineas

5,079 Super User 2025 Season 2

I am new to Power Query.

I am attempting to transform my data and I am getting an error message that says my header column 'Employee Name' of the table wasn't found, even though I can see it in the formula and on the table.

What am I not understanding or misinterpreting?

All responses (3)

Answers (0)

Suggested answer

Jacqui Muller 64 on 13 Mar 2025 at 07:27:07

Like (1)

Report

Issue with Header Names in Power Query

@Phineas & @LoganK What I've also found is that, depending on the source (especially Excel), the column names are in the first row. Then you need to promote (use) the first row as headers before trying to transform the type.
CU13030628-0 2 on 13 Mar 2025 at 06:39:08

Like (0)

Report

Issue with Header Names in Power Query

looks like data source changed, check the header of source table firstly.
LoganK 6 on 11 Mar 2025 at 22:29:04

Like (1)

Report

Issue with Header Names in Power Query

Hi @Phineas! I am running into this very issue at the moment. Did you find a solution?