Skip to main content

Power BI

Needs Votes

Support SQL Server Geometry/Geography data types in Power BI

Vote (613) Share
's profile image

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)
's profile image Profile Picture

4e2ed990 e62a-4956-94cf-e2ae7078a9e9 on 05 Jul 2020 22:19:17

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

This would certainly be the ideal way to be able to do custom mapping areas for our business which has lots of spacial data.

's profile image Profile Picture

3a9a153d 4b38-4ed1-9fda-3e6e1459d0d4 on 05 Jul 2020 22:17:52

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

Please do not forget the Oracle spatial datatype as well.

's profile image Profile Picture

e23f8874 30a0-4fe3-b36a-0265a2fdefde on 05 Jul 2020 22:17:00

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

Yes, including to colour a group of countries, like Europe, North America, etc.

's profile image Profile Picture

4f43ecf4 69d1-496b-b13c-5f8d251e99a1 on 05 Jul 2020 22:16:40

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

Spatial data is very important to my organisation and to visualise geometries in PowerBI would be awesome for our users.

's profile image Profile Picture

987e92c5 31f4-47d9-b2b5-9b4fd9d97a96 on 05 Jul 2020 22:16:33

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

Agree, there is no way to visualize the data by the geography/boundaries that define our business. We need to be able to add boundary shapes to the map whether that is by SQL Server geometry data types, GeoJSON, or shapefiles doesn't matter.

's profile image Profile Picture

174b6a16 44d8-4ae2-8459-a2e94e90b03f on 05 Jul 2020 22:16:08

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

The mapping is not powerful at the moment and needs this sort of feature.