Taking 'First' from unpacked json object

[Anonymous]

I have a MongoDB data, and there is a delivery address json:

{

total order details: such as amount, order number etc

delivery address object:{

first name

last name

some other fields

delivery country

}

}

I dont want to unpack this object because this will duplicate my numbers at a total level, I only want to take a first observation of delivery country per order. 

How can I do that?

[lbendlin]

Try it out.  Have Power BI connect to the list of items, then use List.First  and check if the query still folds.