Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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.
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.