cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.