Using geojson for properties, geometries as a form

[Sibrulotte]

Hi, 

my city has open data about bike paths in a json file:

http://donnees.ville.montreal.qc.ca/dataset/5ea29f40-1b5b-4f34-85b3-7c67088ff536/resource/0dc6612a-b...

So it basically has more than just points, it's a start and end point coordinate. I did the whole convert to table and blow up to rows the records. But I'm just not sure how to possibly unpivot some data to make sure it is usable by a visual in Power Bi.

Has anyone used this type of geojson data? I'd like to add another file on that map that shows accident points that have themselves a single longitude and latitude, bnut that is another question that I'm sure I won't have a problem with.

[v-diye-msft]

Hi @Sibrulotte 

Sorry I can't test the JSON file on my side, could please kindly raise it to support team for better advice? thanks!

https://powerbi.microsoft.com/en-us/support/ 

[Sibrulotte]

Thanks for the interest.

Not sure I should bring a support team for this, as it's just me trying to wrap my head around how to use these files.

[Sibrulotte]

I'm guessing nobody has dabbed with these kind of features...