cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dunner2020
Post Prodigy
Post Prodigy

Importing geojson file in power BI

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:

e04a33ea848c993c638998f7f67889b20bebe392.png

 

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.

 

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Hi @Dunner2020 

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

aj1973_0-1635802041145.png

 

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

aj1973_1-1635802131101.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

3 REPLIES 3
Dunner2020
Post Prodigy
Post Prodigy

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?

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

 

aj1973_0-1635803647788.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

aj1973
Community Champion
Community Champion

Hi @Dunner2020 

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

aj1973_0-1635802041145.png

 

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

aj1973_1-1635802131101.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors