Forum Discussion
PowerBi json parsing
Hi All, I'm new to powerBi and I am having trouble parsing a dynamic column that contains json data. Within the column, the data is being recorded as either records or lists and I am unable to query the specific items within said records and lists. Records and lists look like this respectively,
Record:
{"data":[...]
}
List:
[{"items":[...]
}
2 Replies
daxCommunity Support
Hi vsreepathy,
You could tryto expand the List or Record column, then you could see the detailed information for these columns. You could try to refer to Need Help With Parsing JSON/DataBag Format for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Zoe,
My problem is that the column is a mix between records and lists. When I drill down the column it expands into more records and lists. But when I choose a specific list or record it will then display a list and then within the said list the values that I need.
