SPO column missing from Power Query

[andrew260z]

I have a straight up vanilla text field in my SPO list that I'm trying to import its called  "DisplayName"  there is no evidence of it in power query at all. Its not a calculated column or anything it just holds text. All I can think of is that its using a column name that PowerBI is not able to use?

Ideally I don't want to rename it (Powerapps code will need changing) but I guess if I am forced to I will.

Edit; some screenshots for clarity, the column 'DisplayName' does not apear

Edit 2 - I re-checked the list column name in SharePoint and it is named correctly, reloaded in Powerquery but it cannot find it. I noticed M query handles the ID naming - ID.1

[Greg_Deckler]

Are you certain that you did not create the column as one name and then rename it? SharePoint tends to keep the original column name and simply masks this with a "display name" while under the hood it still references the original name the column was created as. If you could post the full list of SharePoint columns in that list, we might be able to get there through process of elimination.

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.