Forum Discussion
Solved
Need Help With Parsing JSON/DataBag Format
Hi Power BI Community! I'm in need of help on how to parse a column with string value in a JSON/DataBag structure. Normally I would use the auto splitter that's present at the column headers but ...
hi, jimmyswoosh
After my test, you may try this way as below:
Step1:Select column 1 then click Add column->From text->Parse->Json
Step2:
Expand JSON.request
Step3:
Expand other columns
If there are list in the column, Expand to New Rows, then Expand column.
Best Regards,
Lin
That did the trick, thanks!
-James