Forum Discussion

Krishanu's avatar
Krishanu
Helper I
5 years ago

Power Query - Json with varying nested structure

Hi , I have a json with varying and nested structure (below) , which I have to load in indiviual columns in Power Query until the all possible levels. I am struggling with this , please help.  ...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

What issue are you having?  I put your JSON code in a text file called ExampleJSON.json and used Get Data with the JSON connector to automatically get this this point.

 

 

Pat

 

 

  • Krishanu's avatar
    Krishanu
    Helper I
    5 years ago

    Thanks Pat mahoneypat  for responding.

    If you see the last four records,  in serviceExceptionJson column it has nested records.

    I need to expand them as well and there is no limit in number of nesting, I need to go upto the last level -  as long as the nesting goes and bring the data in separate columns/records in Power Query.

     

    Also, I have some files where this serviceExceptionJson column is not present at all, just like initial set of records in your screenshot. Will I have to do something or Power Query automatically handles this?