Forum Discussion
How to PQ this geoJSON file on a map?
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:
Can anyone help?
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
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.
3 Replies
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"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
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.
Thank you. Cracked it.
