Power BI

Needs Votes

Support SQL Server Geometry/Geography data types in Power BI

Vote (719)

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 (78)

Comments (78)

Umar Shaik on 05 Jul 2020 23:09:36

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

Absolutely required. Strange that power bi cant handle major datatypes that sql server supports like goemetry and geography

Sudesh on 05 Jul 2020 23:08:52

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

Is there any work around for this at the moment?

Khaled Kabbach 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 !

AdrianK 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.

Andrew 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?

Brent Leslie 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...