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,
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.