Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lavendercrazze
Regular Visitor

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 data to draw out the polygons? Any pointers is much appreciated. Thank you!

6 REPLIES 6
OkkieW
New Member

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).

v-juanli-msft
Community Support
Community Support

Hi @lavendercrazze

Which map visual do you use?

Could you show me an example of your dataset?

 

Best Regards

Maggie

Hi Maggie,

 

I have attached a sample of the dataset. I am not sure if this data can be used to plot polygons or if it needs any other data to work. This is the visual I tried.

shapeVisual.PNG

This is a sample of the data I am using. 

 

Region IDRegion NameShape
100Region 10x000000000104040000006D618075487260C13F7E2E41B63C514186C0AECDD57160C1BCC3265DC93C5141C89DB23FCC7160C162526C611D3C51416D618075487260C13F7E2E41B63C514101000000020000000001000000FFFFFFFF0000000003
101Region 20x000000000104060000008E9BBD65766A60C17E672F8F6E3B51411156C549636A60C18D514E1F223B5141A91BE9EC9F6260C10CB8436AD1335141D7C347D3A76660C17F6016B9F2225141487E325DCE6B60C1EAB0F0DFC82551418E9BBD65766A60C17E672F8F6E3B514101000000020000000001000000FFFFFFFF0000000003

I am not sure where to start, any links or pointers will be of much help. Thank You!

Hi @lavendercrazze

I'm afraid your data can be used to create the shape map, please have a look at these articles to learn how to create map visualization and how to structure the dataset.

https://docs.microsoft.com/en-us/power-bi/desktop-shape-map

https://www.sqlshack.com/create-geographic-maps-power-bi-using-built-shape-maps/

 

Best Regards

Maggie

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.