Lost columns on expanding JSON

Please check out this file: https://www.dropbox.com/s/bram6131s01nv1t/PBI_ExpandJson.pbix?dl=0

You need to edit the query "Download" with a reference to your local drive

You just have to decide whether to join the tables in the query-editor, which would create one big monster-table, or create a data model, which would be the more professional approach.

Hi sunildatalytyx ,

if the fields are not included in the first 1000 items of the expanded content, then they will not show up.

In that case you have to add them to the M-code manually.

Imagine the automatic expansion had just found "PRN", then you'd add SNR like shown below:

Simply add them to the list with commas as separators.