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: https://github.com/analyticswithadam/...
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.