I am using power query m language. I have created a blank query & written this code
let
Source = #table(
{"first", "second"},
{
{Table.ExpandRecordColumn(Table.FromRecords({[order_id = "a_01", place = "america", price = 700]}), "first", {"order_id", "place", "price"}), "dd"}
}
)
in
Source
Actually I am trying to create a table with code & immediately trying to expand it within first column. But it's showing following error Expression.Error: The column 'first' of the table wasn't found. Details: first
I cannot figure out the problem. Please help me.