Importing geojson data into 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-a7a0-9367aeb8458a

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={"latestWkid"%3A2193%2C"wkid"%3A2193}

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.

1 Like

Hey @leo_89 Let me know if any of the below helps

A Quick Guide to GeoJSONs in Power BI | by Lance McDiffett | Towards Data Science

Use Shape maps in Power BI Desktop (Preview) - Power BI | Microsoft Docs

How To Create Custom Shape Maps for Power BI — DiscoverEI

Hi @DavieJoe , I tried to follow the first link of your reply but it did not work.

1 Like

If the below link does not work then google the article name and you should find the link. Strange how it’s not working as it works for me.

A Quick Guide to GeoJSONs in Power BI | by Lance McDiffett | Towards Data Science

@DavieJoe , Sorry I meant to say that I was following the article and I stuck due to the error I posted in my original post.

1 Like

Hi @leo_89! We noticed that your inquiry was left unsolved for quite some time now.

Looks like your inquiry was out of the experts and users’ bounds.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!