Forum Discussion
Advocate IGeoJSON through OData
Hello,
Is it possible to work with GeoJSON data that is coming from an OData source? After importing the GeoJSON fields are transformed into something that looks like this:
| SRID=4326;POINT (-73.7788888888889 40.6397222222222) |
But when I use these values in the Location fields of the map visualizations they are incorrect. I would prefer to not parse this string to retrieve the longitude and latitude by hand.
If you want to try this yourself an example OData source endpoint with GeoJSON can be found at: http://services.odata.org/V4/(S(uvirdrvfpbph5stgebkebtf2))/TripPinServiceRW/Airports
Zens1,
It is not possible to directly use GeoJSON data in Location of Map visual. You can drag city name to Location to create a map visual instead. Also you can split Point to Latitude and Longitude, then drag Lat/Long fields to create map . For more details, please review the following PBIX file.
https://1drv.ms/u/s!AhsotbnGu1Nok2YkkFQ41BUXDApl
Regards,
Lydia
4 Replies
Zens1,
It is not possible to directly use GeoJSON data in Location of Map visual. You can drag city name to Location to create a map visual instead. Also you can split Point to Latitude and Longitude, then drag Lat/Long fields to create map . For more details, please review the following PBIX file.
https://1drv.ms/u/s!AhsotbnGu1Nok2YkkFQ41BUXDApl
Regards,
Lydia
Zens1Hi Lydia,
Thank you for your response. Splitting the columns is a solution. I'll also start looking into the ideas forum to see if a possible improvement could be made.
Edward
Zens1,
Yes, you can submit a feature request in Power BI ideas forum.
https://ideas.powerbi.com/forums/265200
Regards,
Lydia