Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Support SQL Server Geometry/Geography data types in Power BI

    Vote (719) 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

    Power BI User on 05 Jul 2020 23:26:36

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

    These data types should be part of Power BI Soon

    's profile image Profile Picture

    Omar Mahmood on 05 Jul 2020 23:25:37

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

    If there is a way to show data types like sdo_geometry, it will make life a lot easier.

    's profile image Profile Picture

    Chris on 05 Jul 2020 23:23:05

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

    Definitely need improvements to supported spatial data types and spatial querying. I would also like to see changes over time displayed on maps e.g. heatmaps changing colour with the data

    's profile image Profile Picture

    Scott Stauffer on 05 Jul 2020 23:21:15

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

    Tableau supports Microsoft SQL Server GeoSpatial data types before Microsoft Power BI? What?! Crazy talk... must be an oversight!

    's profile image Profile Picture

    Josiah Raiche on 05 Jul 2020 23:21:12

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

    I'd be happy with an incremental rollout of this - lines and simple polygons would be an excellent start.

    's profile image Profile Picture

    Olivier Travers on 05 Jul 2020 23:18:31

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

    As Ed Saunders pointed out, this is part of Tableau 2018.1...
    https://www.tableau.com/products/new-features#feature-80973

    's profile image Profile Picture

    Dmytro Perepolkin on 05 Jul 2020 23:16:26

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

    We need Microsoft to pick up this project and make it standard https://community.powerbi.com/t5/Best-Visual-Contest/Enhanced-Map-with-Custom-Geography-SQL-Server-compatible-via-WKT/cns-p/7636

    Please, do not leave us one-on-one with proprietary ESRI standards!!!

    's profile image Profile Picture

    Ed Saunders on 05 Jul 2020 23:15:38

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

    This is now supported by Tableau. Seems like a massive oversight that Microsoft hasn't done this yet.

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:15:16

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

    hurry up and do this

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:14:16

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

    2018...done?