Forum Discussion
Dataflow Gen2-To read a JSON data column n load multiple tables named after parent keys
In Dataflow Gen2, there’s no direct option to automatically split a JSON column into multiple tables based on parent keys, but you can do it manually using Power Query. First, use Json.Document to parse the JSON column, then create separate queries for each key by drilling into the relevant parts of the JSON. Each of these queries can be expanded into table format and marked as output tables individually. This way, each parent key's data is loaded into its own table.
In Dataflow Gen2, there’s no direct option to automatically split a JSON column into multiple tables based on parent keys, but you can do it manually using Power Query. First, use Json.Document to parse the JSON column, then create separate queries for each key by drilling into the relevant parts of the JSON. Each of these queries can be expanded into table format and marked as output tables individually. This way, each parent key's data is loaded into its own table.