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 06 Jul 2020 00:17:58

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

It's a shame to have a datatype in MSSQL not supported in PBI

974797f8 793e-4dc8-8402-a118d6288874 on 06 Jul 2020 00:17:51

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

Would be awesome!

6e7d4db6 a787-4835-a10f-c3b44d53523e on 06 Jul 2020 00:16:02

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

How is this possible?

https://www.tableau.com/about/blog/visualize-spatial-data-directly-sql-server-tableau-20181-87377

but no powerbi support?

71166504 623c-4497-b740-a050bcc512fc on 06 Jul 2020 00:10:41

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

This needs to be added ASAP!! Come on MS sort this out - how can you support SQL Spacial Data Types but not be able to visual this data type?

4798ca31 88d4-4c6d-abb1-e575738d2d4d on 06 Jul 2020 00:08:21

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

Please consider adding this. A must have feature.

1db3b521 9c35-45dd-a678-55a049b02e88 on 06 Jul 2020 00:07:06

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

Please, please, please add this functionality! You can do this using SSRS, but it's not the best experience. Why not perfect it in Power BI?

c1980764 7c9b-49d9-b943-0a109fddb716 on 06 Jul 2020 00:02:54

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

This glaring omission is hard to understand..

31f1ca8e 3627-44ee-b66b-db9b080da4c5 on 06 Jul 2020 00:02:05

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

Why is everything so disjointed with and in Microsoft products?

618ccd65 d3a5-4548-bc65-7e59dc6bacf5 on 06 Jul 2020 00:00:51

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

Such a shame Microsoft is faaaaaaaaar behind their competitors in reporting based on maps! What good is that I can store spatial data in SQL Server database if I cannot visualize it properly in a Power BI? This is so often a requirement! To give some business example: a report for property investors showing a circle with a given radius (in meters, individual for each point) supporting decisions if the area is attractive for investments. Drawing spatials on map is not the only required feature. Search capabilities, free hand selection and information about missing points (not recognized points) are MUST HAVE features too. Please, Power BI Team, give us a chance to compete with other BI leaders whenever maps are a part of report!

c20a9185 a51b-40f5-9d97-935d220d98cd on 05 Jul 2020 23:59:08

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

Would LOVE this feature!