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. 😁
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. 😁