Enhanced Map with Custom Geography (SQL Server-compatible via WKT/STAsText)

by deldersveld ‎09-29-2015 04:11 PM - edited ‎09-29-2015 04:31 PM

PBI with Leaflet


The enhanced map for Power BI offers anyone a starting place who would like to incorporate the popular Leaflet JS mapping framework into Power BI. D3 provides scales to handle the fill for polygons (choropleth map) as well as optional areas for points (bubble map).

A set of open source tile layers are provided with attribution to Open Street Map, CartoDB, and Stamen where appropriate. In addition, custom image overlays as well as an option for no base tiles are available.

Integration of SQL Server geography is available via WKT or Well Known Text format using the .STAsText() function. This is more of a proof of concept for integrating Leaflet with Power BI, so other popular geo data formats are not currently available but could certainly be added at a later time.


Video: https://youtu.be/PWOhtSVAP-Y

Code: https://github.com/deldersveld/PowerBI-visuals


People's Choice Tweet: https://twitter.com/dr_eldersveld/status/649001973505626112

by yoshihirok Member
on ‎09-29-2015 06:44 PM

Awesome.Smiley Wink

I want to use Enhanced Map.

Please add map language option, to change map language from English to Japanese.


by deldersveld
on ‎10-02-2015 11:48 AM

I'll have to research whether this can be done on a chart by chart basis. I've never worked with Globalize.JS, which is what the Power BI team is using for internationalization.

by yoshihirok Member
on ‎10-02-2015 09:52 PM

Hi deldervseld.


The Bing map can use Japanese.
But, Power BI' map visual cann not use Japanese.
I hope Power BI's map visual and your Enhanced map to support Japanese.


Yoshihiro Kawabata

by Sandeepkumar New Member
on ‎01-05-2016 03:08 AM

Hi deldersveld,


We want to embed polygon on the filled map in POWER BI. Looks like the steps you have mentioned in the link https://github.com/deldersveld/PowerBI-visuals are talking about loading a map in html page in web application and not about POWER BI.


Could you please help us with any samples / pointers, on how to load polygon in Power BI.




by VJ Frequent Visitor
on ‎04-25-2017 01:47 PM



How to handle polygon Data in power BI ? the feature still does not exist in power BI , any help is appreciated .

by deldersveld
on ‎04-25-2017 02:00 PM

Currently the only way to work with polygon data is to convert it to TopoJSON and use the ShapeMap.

by VJ Frequent Visitor
on ‎04-25-2017 03:23 PM

Hi Del,


in the above video you mentiond we can do it by enhanced map in power BI does that work ?

by deldersveld
on ‎04-25-2017 08:34 PM

This map was just a prototype for a contest. It was never released as a custom visual.