Power BI

Needs Votes

Support SQL Server Geometry/Geography data types in Power BI

Vote (613)

on 09 Feb 2016 05:24:08

The ability to display and create Filled Maps (choropleth) using the native SQL Server geometry/geography data types is a must to allow for meaningful geospatial visualization. e.g. Visualize crimes by police beat.

Comments (66)

Comments (66)

52511263 cd05-408a-8927-fb8ed0edf879 on 05 Jul 2020 23:23:05

RE: Support SQL Server Geometry/Geography data types in Power BI

Definitely need improvements to supported spatial data types and spatial querying. I would also like to see changes over time displayed on maps e.g. heatmaps changing colour with the data

e511e289 4764-414c-aa59-b2f66ee5f4ce on 05 Jul 2020 23:21:15

RE: Support SQL Server Geometry/Geography data types in Power BI

Tableau supports Microsoft SQL Server GeoSpatial data types before Microsoft Power BI? What?! Crazy talk... must be an oversight!

23e8a315 a219-47b2-8e9d-fa379c115c2a on 05 Jul 2020 23:21:12

RE: Support SQL Server Geometry/Geography data types in Power BI

I'd be happy with an incremental rollout of this - lines and simple polygons would be an excellent start.

40502e40 76ce-4f42-b63d-31ddf675aac9 on 05 Jul 2020 23:18:31

RE: Support SQL Server Geometry/Geography data types in Power BI

As Ed Saunders pointed out, this is part of Tableau 2018.1...
https://www.tableau.com/products/new-features#feature-80973

0497139a f9d9-4aa5-bb34-eeca26904f5a on 05 Jul 2020 23:16:26

RE: Support SQL Server Geometry/Geography data types in Power BI

We need Microsoft to pick up this project and make it standard https://community.powerbi.com/t5/Best-Visual-Contest/Enhanced-Map-with-Custom-Geography-SQL-Server-compatible-via-WKT/cns-p/7636

Please, do not leave us one-on-one with proprietary ESRI standards!!!