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

    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

    's profile image Profile Picture

    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!

    's profile image Profile Picture

    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?

    's profile image Profile Picture

    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?

    's profile image Profile Picture

    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.

    's profile image Profile Picture

    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?

    's profile image Profile Picture

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

    's profile image Profile Picture

    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?

    's profile image Profile Picture

    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!

    's profile image Profile Picture

    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!