Issue when going from a list of record to a table

[Anonymous]

Hi All,

I'm parsing JSON with PowerBI and, at some point, I have a list of records.

I can't drill down the list without multiplicating rows, so I wanted to convert them to new columns and found this solution on the forum: 

 #"DecisionDetailed" = Table.TransformColumns(<step>, <column> , each Table.Transpose(Table.FromList(List.Transform(_, each Record.Field(_, "value"))))}})

I works well when "values" is of type Text, but I happen to also have Booleans there and PowerBI generates an error:

"We cannot convert the value false to type Text."

Am I doing this right? Can I force PowerBI to return the boolean anyway?

Thanks,

PC.

[Nolock]

Hi @Anonymous,

please prepare a sample data which doesn't work.