Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
sdertien
New Member

Expanding a column with both List and Record entries

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!

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.