expressionerror he column ledger

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Expression.Error: he column "Ledger" of the table wasn't found

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

resolvedResolved · High Priority · Version 2016

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

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

 

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.07 secs.