Forum Discussion
Solved
JSON column is not expandable
Hi all, hope to find help here, I´m totally new to PBI and JSON and have an issue with expanding some columns in PBI Desktop (and Service as well...) My source seems to be a JSON file which I loa...
Got it.
Simply added at the end of the query the syntax:
#"Expanded Security Level" = Table.ExpandRecordColumn(#"Removed Columns", "Security Level", {"name"}, {"Security Level"})
in
#"Expanded Security Level"Works now. 😁
Hi primlchen ,
usually, the method in this blogpost should work for columns of mixed types: How to expand a column that cannot be expanded in Power BI and Power Query in Excel – The BIccountant
But in your example you actually have an empty column. Could it be that you haven't imported all rows yet?