Power Query Editor unpack JSON

Hello. I have a spreadsheet with 5 columns. One of those columns contains a json array (the array also has nested arrays). Is it possible to use Power Query Editor to parse the json array in each ...

Example.xlsx11 KB

BI & Data Analysis

developer

excel

power bi

DreamDelerium

Oct 29, 2021

I found this worked. I first created a custom column. Then added this as the custom forumla

=if [response_json.sublist] <> false then
Table.ToRecords(Table.FromRecords([response_json.sublist]))
else
Table.ToRecords(
Table.FromRecords({
[option_1 = "null", option_2= "null", option_3= "null"]
})
)

Forum Discussion

Power Query Editor unpack JSON

Resources