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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
LP2803
Responsive Resident
Responsive Resident

Power Query Expand Multiple List columns at a time

Hi Team,

 

I have the data as below.

LP2803_0-1607686212257.png

When I expand to New Records, the List in "column1.videoIn", I get a list of Records

 

LP2803_1-1607686302018.png

 

When i expand the Records i get the below list of columns

LP2803_2-1607686349797.png

 

Post this, I again get list for the columns that i expanded. 

 

LP2803_3-1607686470968.png

 

These lists are further expanded with "Extract Values.." option.

 

So the question is, I have 8 -10 columns where these above expansions are required. Any idea how this can be done dynamically and fast instead of going to every column and expanding it?

 

 

1 REPLY 1
v-yuaj-msft
Community Support
Community Support

Hi @LP2803 ,

 

Sorry for that it's not very clear.

Can you share some sample data and the expected result to have a clear understanding of your question?

You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

 

Best Regards,
Yuna

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.