Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I have some trouble with a JSON file. After opening it and expanding the row with record items (see Image A) I received another column with a mix of records and lists (see Image B). However I couldnt manage to open them ALL at once. Of course I can expand one item but I need all the items.
Solved! Go to Solution.
Hi @raymond
It depends on the data in list and record, add another column, try Record.ToList otherwise thiscolumn, or check the type if type is list then actionA else actionB
@Vera_33 : That worked.
It resulted in a couple of extra steps and finally merging all expanded columns together 🙂
Hi @raymond
It depends on the data in list and record, add another column, try Record.ToList otherwise thiscolumn, or check the type if type is list then actionA else actionB
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |