Expression.Error: The field of the record wasn't found

[Mai_Tran]

Hi guys

I have problem when deleting column in Power Query.

Here are my columns in table 

"Index" column is created by adding index column button in PQ. Now I want to delete it but each time I try to delete column by using function = Table.RemoveColumns(#"Sorted Rows",{"Index"})

It keeps notifying me that 

Expression.Error: The field 'Index' of the record wasn't found.
Details:
NGÀY=01-Jan-25
FLT_DATE=1
FLT_MONTH=1
FLT_YEAR=2025

When I try on deleting another columns, it is still ok. 

Could you guys tell me know what happens with this error notifying?

[Anonymous]

Hi @Mai_Tran ,

Please consider providing the full code, which you can find in the Advanced Editor. For private information such as data sources, you can mask them.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Omid_Motamedise]

Can you provide the whole code of your query?

[Anonymous]

You can just right click on the column and right click, select delete.

But I'm guessing you are referring to the wrong step in your function, as the error is telling you what fields are in the record as of the #"Sorted Rows" step, which doesn't match what we are looking at.

--Nate

[Mai_Tran]

I have try right-click but it doesn't work at all. Every other columns can be deleted except this column. So I don't think that I refer to wrong step 

[uzuntasgokberk]

Hello @Mai_Tran,

Have you tried to delete the step in advance editor and apply it?

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |