List in Power Query is empty

[LP2803]

Hi Team,

I'm trying to get values from List. However when i click on the list and expand it, it gives empty table. 

Also, as far as i know column with List should give us a double headed arrow whcih can be used to expand. I dont see it either.

Below is the image of the same. kindly help me if im missing anything here.

[PhilipTreacy · Accepted solution]

Hi @LP2803 

This line will extract the lists into a comma separated string. 

From this

To this

Insert it into your query and change PreviousStepName to suit your existing query steps

#"Extracted Values" = Table.TransformColumns(PreviousStepName, {"Column1._source.participants", each try Text.Combine(List.Transform(_, Text.From), ",") otherwise "", type text})

Or if you provide your query and data I'll insert it for you. 

As I don't have your data here's a PBIX file to demonstrate how it works.

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[PhilipTreacy]

Hi @LP2803 

The double headed arrow to expand the lists is not shown because one of the values in that column is a space, empty string (blank) or some other whitespace character.

Click on the single drop down arrow at the top of the column to filter those out and then you can expand the lists.

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[PhilipTreacy]

Hi @LP2803 

What is generating the lists?  Why do you expect the list to not be empty?

If you click into the cell beside a List you should see a preview of the list at the bottom of the screen.  They are all empty?

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[amitchandak]

@LP2803 , refer if this blog can help - https://powerbi.microsoft.com/en-us/blog/how-to-expand-a-list-of-records-in-a-query/

[LP2803]

@amitchandak Hi Amit, Im relatively new to the powerQuery and M language. I did go through the link however, I dont see the option to expand the list. when i click on the word "List" it gives me empty. Any other way that you can suggest?