Sharepoint List Lookup missing transform icon

%3CLINGO-SUB%20id%3D%22lingo-sub-2749070%22%20slang%3D%22en-US%22%3ESharepoint%20List%20Lookup%20missing%20transform%20icon%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2749070%22%20slang%3D%22en-US%22%3E%3CP%3EPower%20Query%20options%20missing%20from%20Transformation.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DavidJenkins_0-1631625728514.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310303i87DF5A3ACB053522%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DavidJenkins_0-1631625728514.png%22%20alt%3D%22DavidJenkins_0-1631625728514.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI'm%20attempting%20to%20use%20a%20Sharepoint%20List%20as%20a%20data%20source.%26nbsp%3B%20I%20have%20these%20two%20lookups.%26nbsp%3B%20For%20some%20reason%20the%20icon%20is%20different%20than%20the%20other.%26nbsp%3B%20I%20was%20attempting%20to%20transform%20it%20to%20show%20the%20text.%26nbsp%3B%20When%20I%20click%20%22List%22%20on%20the%20Shipping%20column%20it%20does%20drill%20down%20and%20does%20show%20data.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20anyone%20tell%20me%20what%20is%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2749070%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2751146%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20List%20Lookup%20missing%20transform%20icon%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2751146%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F238903%22%20target%3D%22_blank%22%3E%40David%20Jenkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emaybe%20the%20transform%20cannot%20be%20done%20unless%20you%20expand%20the%20first%20column%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Power Query options missing from Transformation.

DavidJenkins_0-1631625728514.png

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 Replies

@David Jenkins 

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

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.