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

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


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 Established Member
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.