Spatial Data from SQL Table to Power BI Shape (Custom) Mapping

[damit23183]

Hi, 

I am working on to get Spatial data from SQL table to Power BI but during that process I came to know that first thing will have to do is convert Spatial Data into ShapeFIle then to TopoJSON file. 

So I have data like this under spatial column;

Key                 Shape Value

200                 0xE61000001043E590000064........

201                 0xE61000001043E590000018........

Now, I would like to convert this into .SHP file so questions are;

1) How would I convert this into .shp file?

2) How would I use .shp file with Power BI Custom (Shape) file?

Thanks

[Anonymous]

Hi @damit23183 ,

1) I'm not sure if SQL could export the data as shape file.

2) To create shape maps by using your custom topojson files, you can try the following steps without uploading it to Power Query Editors:

1. Using the latest version power bi desktop,( https://www.microsoft.com/en-us/download/details.aspx?id=45331) ,enable Shape map features (Files > Options and settings > Options > Preview features > Shape map visual).
2. When you create a shape map, in Format menu, under Shape options, select ‘+Add map’ and choose your custom .json file.

For further information about shape map, you can refer the following Microsoft document that can also help you:

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

Best Regards,

Jay

[damit23183]

Hi,

THank you for your response. 

I have already done steps you have mentioned before, my current issue is how can generate ShapeFile for Spatial data in SQL table.

1) Is there any 3rd party tool I need to use ?

2) Any Microsoft tool that I can use to convert those data with ShapeFile?

Thanks