Forum Discussion

bluespatial's avatar
bluespatial
New Member
8 years ago

odata spatial service

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?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      bluespatial
      New Member
      8 years ago

      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.