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)

e8da3eee d6d8-4ae6-8181-61371f0e057c on 05 Jul 2020 23:57:33

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

I come from a public office which is considering to use Power BI. This was THE feature we needed, and wil choose Tableau instead, as it has "native" support for the SQL geography.
It's a shame because we use the Office 365 suit, and would have preferred to keep using it.
We would reconsider using Tableu if we had this option.

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:56:32

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

Absolutely a requirement. Please develop.

a7b65f16 1345-483c-a8b1-2339cf69d2f3 on 05 Jul 2020 23:56:30

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

this would be really useful, please add

6de968cc dcca-4d77-b415-384a7788176d on 05 Jul 2020 23:56:00

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

Indeed a must have. please add!

ef6bc5fe 202d-4f0b-8ae2-ee4994d67397 on 05 Jul 2020 23:55:45

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

Very strange this is still not possible in PowerBI. Please make time to develop this musthave in a BI application

6c9f157d 20e2-497a-b706-3786a814329c on 05 Jul 2020 23:54:26

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

This would be a really useful feature. Please add it

016b2b11 7a32-4d2a-9eae-45e5bef56949 on 05 Jul 2020 23:54:25

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

We have a massive data store of geospatial data. Some in MSSQL but all accessible by OGC standard web services (WKT, WMS, WFS, etc).

It's unremarkable that nothing has been done to support Microsoft standard data sets but extremely disappointing that this has been hanging wrounf like a bad smell for 3 years and no updates.

852edcc7 cf35-4824-9e04-c01e08c72299 on 05 Jul 2020 23:52:08

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

I support this. I have multi polygon defined by lat / long data and need to plot these outlines to which I can add layers of other values.

8000adc2 f51b-426d-bd87-d58fa821e6ca on 05 Jul 2020 23:50:53

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

This is an absolute drawback for anyone working with spatial data.

a1589274 5eaa-47f4-8cc6-00d03ab88ae5 on 05 Jul 2020 23:49:33

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

I am using R visuals to display WKT, but a native visual will be amazing