Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good day!
I'm trying to work with a JSON file within PowerBI. For most of the entries I can do "expand to new rows" but I've also a few columns with data and the List value in the same column and I'm not able to expand the data. How can I solve this?
Solved! Go to Solution.
Hi @Sander_NL
You can do a if statement to change the type to list, but if you have many columns with list like the screenshot, you might need to consider other ways instead of expanding each column...
if Value.Is([yourColumn], type list) = true then [yourColumn] else {[yourColumn]}
Thanks Vera this solves the problem!
Hi @Sander_NL
You can do a if statement to change the type to list, but if you have many columns with list like the screenshot, you might need to consider other ways instead of expanding each column...
if Value.Is([yourColumn], type list) = true then [yourColumn] else {[yourColumn]}
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |