GeoJSON through OData

[Zens1]

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

[v-yuezhe-msft · Accepted solution]

@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

[Zens1]

Hi 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

[v-yuezhe-msft]

@Zens1,

Yes, you can submit a feature request in Power BI ideas forum.

https://ideas.powerbi.com/forums/265200

Regards,
Lydia

[Zens1]

@v-yuezhe-msft,

Thanks, I made an idea which can be found at:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34369753-support-direct-use-of-ge...

Edward