How to get column from Record type column

[bejazep]

I'm trying to create a new column from one of the records in a List type column. The value is the country that corresponds with the Latitude and Longitude fields. The information is retrieved from the Bing Map API, which got using Get Data from Web (following the tutorial here: https://sqldusty.com/2016/04/26/power-bi-and-the-bing-maps-api/).

Basically I need List.Record.Record[2].address.countryRegion. Is it possible to make a column that holds this specific value without doing "Expand to new rows"? THe issue is that some of the columns come back with France, and the number of rows increases to over 1000 but there should only be around 250.

[v-jiascu-msft]

Hi @bejazep,

The data in the list is related to the other columns. If you only need a part of them, you can expand the list and then filter the result. If you found out some of the data shouldn't be there, maybe you applied some wrong steps. Since you used a public resource, could you please share your sample? The .pbix file would be great. 

Best Regards!

Dale