Skip to main content

Data Layers

📄️ Working with shapes from databases (WKT / GeoJSON)

Icon Map Pro provides the ability to display shapes that are stored, or referenced via the Power BI semantic model. These shapes are stored either as WKT (Well-known Text) or GeoJSON features. Many popular databases provide the ability to store shapes using the native 'Geography' or 'Geometry' data types, which are then surfaced in Power BI as WKT or geoJSON. Examples of databases providing this capability include, SQL Server, Azure SQL, Fabric SQL, Fabric Warehouse (stored in text fields), Oracle, KustoDB / Eventhouse (stored in text fields), PostgreSQL, Snowflake etc.