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...
v-juanli-msft
Community Support
Community SupportWhich 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.
This is a sample of the data I am using.
| Region ID | Region Name | Shape |
| 100 | Region 1 | 0x000000000104040000006D618075487260C13F7E2E41B63C514186C0AECDD57160C1BCC3265DC93C5141C89DB23FCC7160C162526C611D3C51416D618075487260C13F7E2E41B63C514101000000020000000001000000FFFFFFFF0000000003 |
| 101 | Region 2 | 0x000000000104060000008E9BBD65766A60C17E672F8F6E3B51411156C549636A60C18D514E1F223B5141A91BE9EC9F6260C10CB8436AD1335141D7C347D3A76660C17F6016B9F2225141487E325DCE6B60C1EAB0F0DFC82551418E9BBD65766A60C17E672F8F6E3B514101000000020000000001000000FFFFFFFF0000000003 |
I am not sure where to start, any links or pointers will be of much help. Thank You!
- v-juanli-msft
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