Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.