Draw a polygon based on a json field

[jsteffe]

Hello,
I need to draw all parcels of a vineyard.

I get a table parcel with one ID and a json field which contains coordinates of the parcel polygon. (see below).

How can I draw my parcels polygon with Power BI ?

Thanks for your help.

Jérôme

Content of my json field in table parcel

{
"type": "Feature",
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-0.62993,
44.824363
],
[
-0.629999,
44.82493
],
[
-0.63001,
44.824927
],
[
-0.630285,
44.82484
],
[
-0.630644,
44.824725
],
[
-0.630597,
44.824324
],
[
-0.62993,
44.824363
]
]
]
},
"properties": {"id":15,
"name": "Chenil 3b",
"cepage": "Sauvignon Blanc",
"in_row_distance": 1.1,
"between_row_distance": 1.1,
"year": 2007,
"clone": "530",
"root_stock": "Riparia Gloire de Montpellier",
"orientation": "N-S"
}
}

[amitchandak]

@jsteffe , there is an video on trendlines , see if that can help to do this

https://www.youtube.com/watch?v=xLD8HKwPWHE

[jsteffe]

thanks for your answer.

unfortunetaly, it does not fit. I want to draw my parcels polygons as a map.

[v-kelly-msft]

Hi @jsteffe ,

Check below video for help:

https://www.youtube.com/watch?v=Y2Gu1REoKDU

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!