Forum Discussion
Maps using geometry data from SQL server
Hi, I am trying to map out regions on Power BI desktop from a backend SQL server database. The data for the polygon is stored in Geometry format (0x000000000104...) Is there any way I can use this d...
I like to use the spatial geometry colom of the SQL spatial database. I can see the colom in power_bi and I can see the contens (POINT(117612 516906) in EPSG:28992. I can transform the coordinates to EPSG:4326.
Can I project them in a map whitout using a json or shape file?
I can do this in programs like Arcgis pro. but i can't do this whit the plugin arcgis.
regard
Ouke
A useful answer to this would be greatly appreciated. Until PowerBI can do this, we will not be using it.
agreed. It's a shame that Power BI can't visualise geometry data stored in SQL spatial columns (eg. PostGIS). I'm also finding Power BI rather lacking when trying to render WKT text (without using custom visuals, like Icon Map).
