Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Sander_NL
Helper I
Helper I

Import JSON file not able to expand to new rows

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_0-1644052907209.png

 

Sander_NL_1-1644052945768.png

 

 

1 ACCEPTED SOLUTION
Vera_33
Resident Rockstar
Resident Rockstar

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]}

 

View solution in original post

2 REPLIES 2
Sander_NL
Helper I
Helper I

Thanks Vera this solves the problem!

Vera_33
Resident Rockstar
Resident Rockstar

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]}

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.