How do you use GeoJSON in Power BI? Keeps deleting half the coordinate pair!

[jsaue003]

I got my GeoJSON data from Airbnb's public data. Feel free to get a copy yourself, completely safe http://insideairbnb.com/get-the-data.html. I chose the following Amsterdam geojson file:

Amsterdam

neighbourhoods.geojson

Here is a video demonstration of the issue (don't worry--no sound). You can CLEARLY see when I drill in there is a coordinate pair, but when I expand all the rows, there's just one coordinate. It's deleting everything.

Here is my question.... How do you actually work with this GeoJSON data in PowerBI properly, and graph it on a map? 

[Stachu]

with each step in the video you navigate to particular list/record, completely disregarding the other data

in the video in 0:26 you should convert  the list to a table and then expand the records, rather than navigating into one of them

this should generate code similar to this one

let
    Source = Json.Document(File.Contents("C:\folder\neighbourhoods.geojson")),
    features = Source[features],
    #"Converted to Table" = Table.FromList(features, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"type", "geometry", "properties"}, {"Column1.type", "Column1.geometry", "Column1.properties"}),
    #"Expanded Column1.geometry" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1.geometry", {"type", "coordinates"}, {"type", "coordinates"}),
    #"Expanded Column1.properties" = Table.ExpandRecordColumn(#"Expanded Column1.geometry", "Column1.properties", {"neighbourhood", "neighbourhood_group"}, {"neighbourhood", "neighbourhood_group"}),
    #"Expanded coordinates" = Table.ExpandListColumn(#"Expanded Column1.properties", "coordinates"),
    #"Expanded coordinates1" = Table.ExpandListColumn(#"Expanded coordinates", "coordinates"),
    #"Expanded coordinates2" = Table.ExpandListColumn(#"Expanded coordinates1", "coordinates"),
    #"Extracted Values" = Table.TransformColumns(#"Expanded coordinates2", {"coordinates", each Text.Combine(List.Transform(_, Text.From), ","), type text})
in
    #"Extracted Values"