Unable to expand columns in Power BI

[Anonymous]

Hi All,

I am trying to connect to REST API using web as a connection. After I load the data, I converted the list to table and I can see all the columns now, but there are few columns which are still not expanded and it is showing as [RECORD] for all the line items. "Expand to table" option is missing. Can someone please let me know how to get the column values populated in the same table.

Thanks

Poojitha

[Anonymous]

Advanced editor code as been updated in the question.

[Anonymous · Accepted solution]

I got it working now. Code is as below

TransformToList = Table.TransformColumns(#"Expanded Value1", {{"column Name", each if Value.Is(_, type record) then _ else [a=_]}}),