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
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.
Advocate IIHi
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.
- ImkeF
Yes, you have to edit the code to adjust it to your query:
"Source" needs to be replaced by the name of the step that contains the table you want to operate this on (which is usually the name of the previous step) and "Column1" needs to be replaced by the name of your column "Value".
You might find these links helpful:
How to integrate M-code into your solution -- Check out more PBI- learning resources here