Icon Map Capabilities and Guide
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
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.
Hi James,
Thank you so much for your help. Your Icon Map visual is legendary.