Table inside Table in columns

AnonymousI can seee that you have used Odata.Feed.

As far as I know, you can utilize scripting inside Odata.Feed to select your columns

https://docs.microsoft.com/en-us/powerquery-m/odata-feed

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect?view=azure-devops

If you don't succeed there, you need to manually select your column like following

 {"fruits":[
{
kind: "grape",
"color":[{
color1: "red",
color2:"green"
}],
quantity: 12,
tasty: true
},
{
kind: "kiwi",
"color":[{
color1: "brown",
color2:"green"
}],
quantity: 98,
tasty: true
},
{
kind: "mango",
"color":[{
color1: "yellow",
color2:"green"
}],
quantity: 0,
tasty: true
}
]
}

fruits2.json

let
    Source = Json.Document(File.Contents("C:\Users\X\Desktop\fruits2.json")),
    fruits = Source[fruits],
    #"Converted to Table" = Table.FromList(fruits, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"kind", "color", "quantity", "tasty"}, {"kind", "color", "quantity", "tasty"}),
    #"Expanded color" = Table.ExpandListColumn(#"Expanded Column1", "color"),
    #"Expanded color1" = Table.ExpandRecordColumn(#"Expanded color", "color", {"color1"}, {"color1"})
in
    #"Expanded color1"

Anonymouscan you please provide a snapshot and the sample query. You can expand the desired columns as mentioned in #"Expanded Count"

let
    Source = #table({"First Column", "Second Column"}, {{1,2},{3,4}}),
    #"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type),
    #"Grouped Rows" = Table.Group(#"Added Index", {"Index"}, {{"Count", each _, type table [First Column=number, Second Column=number, Index=number]}}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"First Column"}, {"First Column"})
in
    #"Expanded Count"

If it helps, fyi that you can pass filters and select certains columns to be returned by adding paramters to your web call using ?$filter=...&$select=...

You can likely improve performance of your refresh, and you would only see the columns you selected when you go to expand.

Regards,

Pat