Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
BioGeekJoey
New Member

Expanding a column with mixed lists and records from JSON

‎09-28-2017 02:18 AM

I'm importing data from a JSON API and there's one column that contains both lists and records. It can not be expanded in any way I tried.

 

 

 

I'm new to using power bi and excel power query, I tried both the interface options and with some M editing but I can't find a solution.

 

Thanks in advance 🙂 

Message 1 of 2
3,429 Views
0
1 REPLY 1
v-yulgu-msft
Microsoft Employee
Microsoft Employee

‎09-28-2017 11:36 PM

Hi @BioGeekJoey,

 

Here is a similar thread for your reference

Transforming json with power query (mix of list and record in a single column)

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 2
3,397 Views

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All