Skip to main content
Microsoft Idea

Power BI

Under Review

Allow the ability to render polygons or lines if the datatype of a field in a table is set to Geospatial

Vote (88) Share
Jayce Lane's profile image

Jayce Lane on 26 Feb 2015 20:17:25

Hopefully the description said it all.

Comments (9)
Jayce Lane's profile image Profile Picture

Dmytro Perepolkin on 05 Jul 2020 23:16:25

RE: Allow the ability to render polygons or lines if the datatype of a field in a table is set to Geospatial

Please, do not reinvent the wheel. We need ability to plot WKT/WKB columns (please, take inspiration in Simple Features package in R)

Jayce Lane's profile image Profile Picture

David Cresp on 05 Jul 2020 23:14:26

RE: Allow the ability to render polygons or lines if the datatype of a field in a table is set to Geospatial

The Power Map feature in Excel provides the ability to add in Polygons to maps but not Power BI. This is a feature that is really lacking in Power BI. One that is handled really well in Tableau though. Please MS have a look at this really badly needed feature.

Jayce Lane's profile image Profile Picture

Doug Kampe on 05 Jul 2020 22:36:34

RE: Allow the ability to render polygons or lines if the datatype of a field in a table is set to Geospatial

The geospatial aspect of PowerBI is lacking. If I can store the shape in SQL Spatial, I should be able to render it in PowerBI. I do all my geospatial analysis in ESRI and export directly to a SQL database set up for BI. My work analyzes bus route optimization, but I can do everything in PowerBI like evaluate efficiencies of existing routes and suggest alternate routes, but I cannot actually show the polylines routes on the map. I thought the ArcGIS extension would solve this, but it doesn't come close. Actually, I'm not sure what the ArcGIS extension does. Please include support for geometry and geography types.

Jayce Lane's profile image Profile Picture

Power BI User on 05 Jul 2020 22:36:06

RE: Allow the ability to render polygons or lines if the datatype of a field in a table is set to Geospatial

this arcgis solution is shit

Jayce Lane's profile image Profile Picture

John Little on 05 Jul 2020 22:27:40

RE: Allow the ability to render polygons or lines if the datatype of a field in a table is set to Geospatial

Need this to show franchisees the area serviced by a franchise

Jayce Lane's profile image Profile Picture

Marcos Freccia on 05 Jul 2020 22:24:38

RE: Allow the ability to render polygons or lines if the datatype of a field in a table is set to Geospatial

I want this! No more explanations on why we need it :)

Jayce Lane's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:53

RE: Allow the ability to render polygons or lines if the datatype of a field in a table is set to Geospatial

For example I can directly add shape information I get as Open Data from the Alberta provincial government in Canada and can directly import into Tibco Spotfire. There is a workaround for Tableau.

Jayce Lane's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:52

RE: Allow the ability to render polygons or lines if the datatype of a field in a table is set to Geospatial

I would like to understand what encompasses redering. Does this include the ability to read shape files or attach to an ESRI SDE database?

Jayce Lane's profile image Profile Picture

Power BI User on 05 Jul 2020 22:06:35

RE: Allow the ability to render polygons or lines if the datatype of a field in a table is set to Geospatial

Would also be nice to do polygon to polygon calculations as DocumentDB does now.