Skip to main content

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

0497139a f9d9-4aa5-bb34-eeca26904f5a 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

4e2ed990 e62a-4956-94cf-e2ae7078a9e9 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

670bf121 6bfc-4cad-ae1f-6893edbe16ca 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

859838d0 4a95-4e09-af9b-7906c63ba0e9 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

23904a32 5a81-47b1-ac99-50c5494a4c76 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

c5fa047b 4934-4498-a7b4-7f77780067bf 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

ce0a3c41 a973-4219-b6c3-db0e8df29d0d 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

ce0a3c41 a973-4219-b6c3-db0e8df29d0d 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

1117ef18 4d0d-4c05-a464-0b47fbfbcb27 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.