Forum Discussion
Power Query - JSON Schema - Include elements not present in first (2) expanded objects
I did that taking the json from the text in the table, not from external file, but it shall be no difference. That is on Windows Desktop app
Now repeated the same from the file. Steps are
Get Data->From file->From JSON
Click on Lists in records
Convert List to Table
Expand column
Expand record column with Lists. Record appears as value
Expand it again and here click on Load more
With that it shows metadata field
Finally expand metadata
which gives
Above steps are in Sample query in attached file, you shall only change the file path on the first step to repeat.
I did that taking the json from the text in the table, not from external file, but it shall be no difference. That is on Windows Desktop app
Now repeated the same from the file. Steps are
Get Data->From file->From JSON
Click on Lists in records
Convert List to Table
Expand column
Expand record column with Lists. Record appears as value
Expand it again and here click on Load more
With that it shows metadata field
Finally expand metadata
which gives
Above steps are in Sample query in attached file, you shall only change the file path on the first step to repeat.
Thank you very much again for your assistance.
I think we've found the issue - Excel for Mac does not have the 'load more' option when expanding the column.
Since my previous reply, I sent the two example source data files to a colleague who uses Widows, and their observations were exactly as yours.
I wonder if there's some way to raise this as a bug/enhancement request?
Sincere thanks again for your help,
Rob.
Rob_Bolton , you are welcome.
Never worked on Mac, on Windows you may within Excel go to Help->Feedback->Report a problem.
Or even better is to post an issue on feedback portal Excel · Community (microsoft.com)
