Importing geojson file in power BI

[Dunner2020]

Hi there,

I want to read “Crash analysis system” dataset hosted on the following link:

https://catalogue.data.govt.nz/dataset/crash-analysis-system-cas-data/resource/c16a0a0c-057e-4122-a7...

The dataset is in geojson format. I used the web option to get the data and entered the following link to read the geojson dataset:

https://opendata-nzta.opendata.arcgis.com/datasets/8d684f1841fa4dbea6afaefc8a1ba0fc_0.geojson?outSR=...

Power BI started reading the data from the link. However, after a while it throws the following error:

I never imported geojson file into Power BI file. I am not sure where I am making the mistake. Any help to import geojson data into Power Bi would be really appreciated.

[Dunner2020]

Thanks for your reply @aj1973 , you said you converted to *json by deleting geo. Are you referring to remove geo from the below link?

https://opendata-nzta.opendata.arcgis.com/datasets/8d684f1841fa4dbea6afaefc8a1ba0fc_0.geojson?outSR=...

or is there anyother place I need to make change?

[aj1973]

No, you cant delet it from the URL. after you download the file to your machine

[aj1973 · Accepted solution]

Hi @Dunner2020 

I converted the file to *.jason instead of *.geojason. just delete "geo" from the extension

However it took time to import the file into Power Query, maybe using CSV file is better.