PROSE group header - blue background

PROSE – Json Extraction

PROSE can automatically flatten a JSON file into a table. It supports extracting Newline Delimited Json (opens in new tab) and truncated Json.

Currently we support code generation in Python, Pyspark, and M.

This feature is shipped in Power Query/Power BI Power Query JSON connector | Microsoft Docs (opens in new tab)