Icon Map Capabilities and Guide

Icon Map is a custom visual providing a flexible set of mapping capabilities for Power BI. Background layers: A choice of raster background layers including custom URLs that can be configur...

how to

wins123

Frequent Visitor

2 years ago

Hi I am trying to figure out how to commit Geojson information to the dataset as noted in the update,

Added ability to display GeoJSON shapes stored within the Power BI dataset. These are added in the same way as WKT content. The visual now supports a mixture of GeoJSON, WKT and images stored in the dataset.

I understand how the formatting of the data for WKT works within the dataset but unsure of how to implement my geojson file.

Any examples would be greatly appreciated.

Thanks

jamesdales
Kudo Kingpin
2 years ago
Using some of the examples from https://docs.snowflake.com/en/sql-reference/data-types-geospatial

If you have two rows of data, a point and a linestring, the WKT would look like:

POINT(-122.35 37.55)
LINESTRING(-124.2 42,-120.01 41.99)

The equivalent 2 rows of geojson would look like:

{ "coordinates": [-122.35, 37.55], "type": "Point" }
{ "coordinates": [[-124.2, 42], [-120.01, 41.99]], "type": "LineString" }

Given PowerQuery has a max character limit of just over 30000 characters, I'd recommend using WKT over GeoJSON if you can as it's more compact.
- wins123
  Frequent Visitor
  2 years ago
  Hi James,
  
  Thank you so much for your help. Your Icon Map visual is legendary.