How can we improve Power BI?

Support SQL Server Geometry/Geography data types in Power BI

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.

503 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

48 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Umar Shaik commented  ·   ·  Flag as inappropriate

    Absolutely required. Strange that power bi cant handle major datatypes that sql server supports like goemetry and geography

  • AdrianK commented  ·   ·  Flag as inappropriate

    I also support native direct display of geometry and geography types selected by query etc. from a db. It seems very odd that it is not possible to easily display MS SQL Server spatial objects with a MS data visualisation tool. I'm not expecting full GIS capabilities (line, points and polygons display control is a must), but it should be possible to in-house publish private company data without have to export and convert via third party tools. The ESRI plugin may not be appropriate for data licence/protection either.

  • Andrew commented  ·   ·  Flag as inappropriate

    Has this been implemented and if so where can we view this data?

  • Brent Leslie commented  ·   ·  Flag as inappropriate

    Amazing that Microsoft makes a product for storing data and a product for displaying data, yet the two do not understand each others data types! The Geography type works, but PowerBI confuses Lattitude/Longitude so your map is all over the place...

  • Ralph Kemperdick commented  ·   ·  Flag as inappropriate

    How about adding a Lasso feature to select a collection of given data points within the map, by drawing the boundaries around the dot's?

  • Christo commented  ·   ·  Flag as inappropriate

    This is currently a big limitation for displaying spatial data. This feature is needed desperately.

  • Avron commented  ·   ·  Flag as inappropriate

    Spatial Data especially for Oil and Gas industry mapping out Coal Basins - can't wait for this supported type

  • Doug commented  ·   ·  Flag as inappropriate

    Spatial data support other than just X/Y is absolutely necessary and growing in importance to organizations.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.