Power BI: Expand JSON Array Column to New Table

[@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.

[@mishkanhaorot]

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

[@Richardmhwsa]

You are a lifesaver! Thank you!

[@melissatan5729]

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!

[@JonGallant]

Glad it helped!

[@daniloduofini]

Thats was exactly what i am looking for!
Thanks!

[@filibertogarced]

Thanks for the useful information!

[@baj_]

Just what I was looking for, thanks you!!

[@DeepakChauhan-wu7ei]

Thank you for simple explanation. This relly helped me

[@leahfarine1535]

You explained that so clearly! Thank you.

[@LewisWong-h4t]

A clean explanation!

[@trycatchangler]

Can this same technique be applied to a SharePoint column with JSON data?

[@mikelaw4036]

outstanding

[@papachoudhary5482]

Thanks! Sir, its GREAT
Have a blessed day

[@claudioaguila5299]

thanks a lot!!

[@legendgod]

Could you explain Table, List and Record?

[@erdrick22]

Thanks very helpful

[@stereoanimal]

mmm mmm mmm muchas gracias!

[@JonGallant]

:)

[@BiEslava]

thanks so much

[@bryansiachua]

Is it possible from excel to json?

[@JonGallant]

You can probably export excel to json using excel tools. But if going to PBI, just keep in excel?

[@r1krdo_7]

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