Expression.Error: he column "Ledger" of the table wasn't found

Resolved · High Priority · Version 2016

Fri 30 Oct 2020, 12:29 Delegate Alex said...

Alex has attended:
Excel Advanced - For Power Users course

Expression.Error: he column "Ledger" of the table wasn't found

Hi,

In Power query editor when I try to change edit my columns and remove the top row I get the above error message

Does anyone know what might be causing this issue with the column labelled ledger

Fri 30 Oct 2020, 13:42 Trainer Jens said...

RE: Expression.Error: he column "Ledger" of the table wasn't fou

Hi Alex,

Thank you for the forum question.

Have you changed the the header name from "ledger" to something else?

When you look at the steps to the right, do you add the step under the last step?

On the view tab click Advanced editor and copy the code and paste it here in the forum so I can have a look at it.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.7 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

General Shortcuts

Ctrl + S: Save the report or dashboard.
Ctrl + Z: Undo the last action.
Ctrl + Y: Redo the last undone action.
Ctrl + C: Copy selected items.
Ctrl + X: Cut selected items.
Ctrl + V: Paste copied or cut items.
Ctrl + A: Select all items.
Ctrl + N: Create a new report or dashboard.

View all Power BI hints and tips