Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Power Query has several functions that support JSON parsing. Use these.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |