Sharepoint List Lookup missing transform icon

[David Jenkins]

Power Query options missing from Transformation.

I'm attempting to use a Sharepoint List as a data source.  I have these two lookups.  For some reason the icon is different than the other.  I was attempting to transform it to show the text.  When I click "List" on the Shipping column it does drill down and does show data.

Can anyone tell me what is wrong?

[#2]

@David Jenkins 

maybe the transform cannot be done unless you expand the first column

[#3]

Yeah but apparently I can't expand this using the Sharepoint option for a data source.

I have switched to the ODATA service for Sharepoint. It is much better and contains all the data. I think it's faster too.