How to PQ this geoJSON file on a map?

[TomTomTom]

I'd like to be able to use this geojson file into maps on PowerBI, where I would then overlay other info, but I can't seem to get the query right:

geojson file in question

Can anyone help?

[artemus]

The query will look like:

let
    Source = Json.Document(File.Contents("<Your file location>")),
    features = Source[features],
    Custom1 = Table.FromRecords(features),
    #"Expanded properties" = Table.ExpandRecordColumn(Custom1, "properties", {"FID", "CCG19CD", "CCG19NM", "BNG_E", "BNG_N", "LONG", "LAT", "Shape__Area", "Shape__Length"}, {"FID", "CCG19CD", "CCG19NM", "BNG_E", "BNG_N", "LONG", "LAT", "Shape__Area", "Shape__Length"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded properties",{"geometry"})
in
    #"Removed Columns"

[HotChilli · Accepted solution]

Hello,

I saw the other post you made about maps and I wonder if your problem remains unsolved.  Are you actually trying to use the map you have as a shapemap?

If so, you might find this thread helpful

https://community.powerbi.com/t5/Power-Query/Importing-TopoJSON-file-to-create-shape-map-what-Next/m... 

Also, read this first https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map#use-custom-maps 

You have a geojson map , you need a topojson version of it.  It may exist already (on the web) or you can make it yourself with mapshaper (again, on the web)

Get back to me if you need more help.

[TomTomTom]

Thank you. Cracked it.