Forum Discussion
Lost columns on expanding JSON
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.
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.
24 Replies
Can you post your JSON or a sample of it?
Hi smoupre
Many thanks for picking up on my issue.
Below is a Dropbox link to the zipped files.
The folder contains 9 JSON files representing 9 horse races.
I used "Combine and Edit" to get the data into Power BI.
The rest of the scenario is described in my screen-shots in my original post.
If you need any additional information please let me know.
Thank you, Mark.
https://www.dropbox.com/s/xthmfddgiy1s1dl/Greyville%207.5.2017%20Json%20race%20files.zip?dl=0
Hi again smoupre
I found the tutorial below that seems to provide a solution.
Rather than wasting your time, I'll try the solution and if it works I'll post any comments.
Either way, I'll update this topic with my outcome.
Thanks for assisting, Mark.
