Import JSON file not able to expand to new rows

[Sander_NL]

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?

[Sander_NL]

Thanks Vera this solves the problem!

[Vera_33 · Accepted 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]}