odata spatial service

[bluespatial]

I have setup an OData service that imports into powerBI fine. 

https://demo.bluespatial.com/odata/layers/Schools1?$top=20

However when I add a map vizualization and set the Location to the geometry field nothing happens / the geometries are not drawn. 

I am leveraging code from Github - https://github.com/OData/ODataSamples/tree/master/WebApi/v4/ODataSpatialSample which returns the geometries as MS Geometry JSON format.

Should I be returning as TopoJSON or some other format for my REST endpoint to be able to function with Power BI?

[Anonymous]

@bluespatial,

Which field do you set the Location type? I put all data into a JSON file and connect to the JSON file in Power BI Desktop, then extract all columns and create a map using the city column, please check if it returns your expected result.

https://1drv.ms/u/s!AhsotbnGu1Nok0pvPuF9WuASni7G

Regards,
Lydia

[bluespatial]

My geometry are pregeocoded. I am not trying to specify a city which is then geocoded and then placed on the map. I have the actual coordinates. Also I have more than just point geometries. I also have polygons etc. 

I also need to know if it will work with OData with a spatial field.