Forum Discussion
Unspool object data from MongoDB
I have data from MongoDB and some of the entries there are nested. I load them into PowerBI (using Atlas Mongo BI connector) and most of it is fine except for nested items, they look like in screenshots.
Is there a way to unwind it so I can query variables inside thes nested objects? such as aggregate prices or group by name?
1 Reply
Power Query has several functions that support JSON parsing. Use these.
