Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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.
Image A
Image B
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
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
72 | |
71 | |
51 | |
48 |
User | Count |
---|---|
45 | |
38 | |
33 | |
30 | |
28 |