Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I have a series of JSON documents that I'm querying over where at a particular level the resulting data is either a list or a record. In the case where the data is shown as a List the JSON is typically a block of nodes like this:
"Nodes": { "Node": [ { "OS": { "_name": "Windows Server 2012 R2", "_vendor": "Unknown", "_version": "6.3", "_arch": "Unknown" }, "_id": "HOST1", "_cpu": "amd64" }, { "OS": { "_name": "Unknown", "_vendor": "Unknown", "_version": "Unknown", "_arch": "Unknown" }, "_id": "HOST2", "_cpu": "Unknown" } ] }
In the case where it's listed as a Record it's a single record of the same data as follows:
"Nodes": { "Node": { "OS": { "_name": "Windows Server 2008 R2", "_vendor": "Unknown", "_version": "6.1", "_arch": "Unknown" }, "_id": "HOST1", "_cpu": "amd64" } }
Being extremely new to working this in Power BI I'm assuming that since I'm out of options in the Desktop UI that I likely need to parse this down using M code. I'm assuming I can test if the type of entry is a List or a Record and IF/Else the results but I can't seem to figure out the right sequence. I've seen a few other examples but haven't been able to get those to work and get a result. Any pointers? Thanks!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
85 | |
70 | |
68 | |
50 | |
32 |
User | Count |
---|---|
117 | |
100 | |
73 | |
65 | |
40 |