Skip to main content
Microsoft Idea

Power BI

Needs Votes

Support SQL Server Geometry/Geography data types in Power BI

Vote (718) 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 (78)
's profile image Profile Picture

Peter Nolder on 08 Sep 2023 06:57:53

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

This would be useful to me for plotting utilities that i report on. There are some route map visualizations out there but a multi point vector type option would be great!

's profile image Profile Picture

Bobby Neelon on 27 Jun 2023 03:06:31

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

What Zack and Jeff said...


But seriously, that's probably the one feature keeping our company from moving to Power BI as our main BI/Visualizatoin tool.

's profile image Profile Picture

Jeff Hughes on 26 Jun 2023 20:30:04

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

Zack's right you know..

's profile image Profile Picture

Zack Warren on 26 Jun 2023 20:29:17

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

This is huge for geospatial industries like O&G, defense, transportation, real estate, etc. Please bump up!

's profile image Profile Picture

Tim Minter on 17 Oct 2022 16:27:34

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

location information technology and data structures have been widely commercially available since at least the 1980s, which if I'm counting right... just ran out of fingers.


so, why not?

  • is it unpossible?
  • are place name conceptual tokens sufficient for representing where things are? hint: no, they are not.
  • is it strategery?
  • does most of the stuff we report on in Power BI not have an associated location element?
  • do we not need to understand spatial relationships among our stuff?
's profile image Profile Picture

Daniel Schwegler on 25 Oct 2021 09:51:48

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

Dear Microsoft, Please support this feature for the on-prem data gateway. It a must have feature, and support your own geometry/geography data type from SQL Server seems a very reasonable move. Is needed for C3/C4 classified data wich resides on-premises sql databases.

's profile image Profile Picture

Geoff Martin on 19 Oct 2021 20:40:19

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

Displaying SQL geometry/geography data in a Map Visual is a must. We have tonnes of point/line/polygon spatial data we would like to display in BI.

's profile image Profile Picture

Luke Garton on 19 Oct 2021 01:13:44

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

Microsoft doesnt even support its own SQL server data type... Crazy!

's profile image Profile Picture

Shawqi Saad on 02 Aug 2021 18:04:38

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

Please add this feature. I am trying to make a shapefile with roadways in a small city however the shapefile is all over the place. 

's profile image Profile Picture

Julio Cesar Rosado Cordova on 09 Dec 2020 19:19:39

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

Please, add this functionality.
it is extremely useful