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)

2232dce4 4801-4e19-b265-3bd01efd1cd7 on 05 Jul 2020 23:08:22

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

this will add a great Power to Power BI !

4566ddf6 81b9-4d09-9349-52fb4c40d4d8 on 05 Jul 2020 23:08:10

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

I also support native direct display of geometry and geography types selected by query etc. from a db. It seems very odd that it is not possible to easily display MS SQL Server spatial objects with a MS data visualisation tool. I'm not expecting full GIS capabilities (line, points and polygons display control is a must), but it should be possible to in-house publish private company data without have to export and convert via third party tools. The ESRI plugin may not be appropriate for data licence/protection either.

3ddae3b3 5866-4cd1-a389-19ef1430494f on 05 Jul 2020 23:03:07

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

Has this been implemented and if so where can we view this data?

4f9df6c7 6f89-4a15-b7f6-1ddf6affa7fc on 05 Jul 2020 23:02:48

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

Amazing that Microsoft makes a product for storing data and a product for displaying data, yet the two do not understand each others data types! The Geography type works, but PowerBI confuses Lattitude/Longitude so your map is all over the place...