Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |