How to Parse JSON with Power Query in Excel

preview_player
Показать описание

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.
Рекомендации по теме
Комментарии
Автор

that's awesome Adam!
Thank you for sharing.

PatrickBateman