Forum Discussion
Advocate IILost 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.
Advocate IIHi 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.
Advocate IIHi
I tried to fllow the video but I suspect that adding columns to a column that hasn't been expanded is problematic.
Not sure?
I get a different error to the one expected accordng to the video.
Please see screen-shots of my attempt below.
Your assistance will be greatly appreciated.
Thanks, Mark.
- Skemaz
Hi
The images posted individually below (seem a bit tiny posted as a single combined image).
Thanks, Mark.
- ImkeF
Community Champion
There's a fairly easy way to fix this: http://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi-and-power-query-in-excel/
- Skemaz
Hi ImkeF
Thank you very much for your assistance, however I'm still stuck with an almost identical error as when I tried the Youtube video solution ... "Expression error: We cannot covert a value of type Table to type Text."
If you'd like any additonal information please let em know.
Below are some screen-shots of what I see.
Thanks, Mark.