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 ...
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 Zhi
If 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.
