Lost columns on expanding JSON

[Skemaz]

Hi

Please view the two screen-shots below.

I am trying to keep the column shown in the top screen but lose it when I convert to table.

Any assistance will be appreciated.

Thanks, Mark.

[ImkeF · Accepted solution]

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.

[ImkeF · Accepted solution]

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.

[sunildatalytyx]

Thank you Imke, thank you for the response, appreciate it. I've realised over time the below response and added the fields manually. Thanks

[Skemaz]

I'm away from my computer at the moment (in Sydney, Australia).
I'll check that out as soon as I get home.
Many thanks indeed. I know I'll get this working - all thanks to your help.
Best regards, Mark.

[Skemaz]

All of them please. I intend to create visualizers that show horse speeds and locations relative to one another over time. I hope that makes sense. Thanks.