How to Parse JSON with Power Query in Excel

The Excel file uses for this example is avaliable in GitHub if you want to follow along here: github.com/ana...
In this video we show how to Parse JSON in Excel with the Parse JSON functionality in Microsoft Power Query. Parsing JSON columns in Power Query is not difficult but there are a few pitfalls you can fall in to.
The Parse JSON function in Power Query provides a really flexible way to Parse JSON for excel as you can immediately exclude columns that you don't want in the final data and will all Power Query implementations it is repeatable and reusable for other datasets.

[@gram01000]

Good detailed steps!

[@PatrickBateman12420]

Ahhhhhh, that's awesome Adam!
Thank you for sharing.

[@analyticswithadam]

Thanks for the feedback Patrick. Any other Power Query topics you would find useful?

[@PatrickBateman12420]

@@analyticswithadam Well, since you asked 🙂I'm sure that many viewer would like to understand why in Excel, we have to install a driver to connect to a Postgresql while in Power BI, we don't ....

[@analyticswithadam]

@@PatrickBateman12420 One word answer: Microsoft. Its getting better though.