Power BI: Expand JSON Array Column to New Table

Let's expand a JSON array column to a new table so you can slice and dice by properties in that array.

It took me too long to figure this out - so hope this saves you some time.

@bradygaster was a guest in my test data :)

[MedioAmbientecommx]

One of the most useful video tutorials i've ever seen. Thank you very much! Also thanks for making it so easy to watch, without background music, clear speaking etc.

[leahfarine]

You explained that so clearly! Thank you.

[mishkanhaorot]

You rock! This saved me today. Thanks so much.

[baj_]

Just what I was looking for, thanks you!!

[melissatan]

Super handy and really useful. I was searching how I could expand nested JSON arrays in a query that is returning in a JSON format initially. I wanted to make separate tables from those nested arrays and this really help me understand how I can do it!

[daniloduofini]

Thats was exactly what i am looking for!
Thanks!

[DeepakChauhan-wuei]

Thank you for simple explanation. This relly helped me

[papachoudhary]

Thanks! Sir, its GREAT
Have a blessed day

[legendgod]

Could you explain Table, List and Record?

[rkrdo_]

Man me salvastes la Vida estaba pariendo para separarlo y con esto pude importar los datos y poder serparar el json de forma más sencilla