cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vsreepathy Frequent Visitor
Frequent Visitor

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 2
Community Support Team
Community Support Team

Re: PowerBi json parsing

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.

vsreepathy Frequent Visitor
Frequent Visitor

Re: PowerBi json parsing

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. 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 3,160 guests
Please welcome our newest community members: