Forum Discussion
Sharepoint sublists not appearing in Power Query
Not sure what you mean by sublists, are you using the SP folder connector? Do you have any filter or navigation steps under applied steps on the right that were perhaps unintentional? The query text at the very top is somewhat clipped but it looks like there's a filter step above.
Thank you for the response,
I have tried both SP folder and SP online list, in this case I am using a SP online list connector with a 2.0 implementation. The steps are just the source and the filter & navigation ones to choose the selected list (inside which the sublists are). As I have seen in other posts, I should be able to see the list and sublists inside them all at once in the same table but I am only seeing the first list.
Maybe they are not called sublists but what I mean is: Imagine you have a SP list about countries and their info, and one column is "Capital" which is another list embedded into it. I can't see the info about capitals. Hope this clarifies it.
Thanks a lot for the time and patience!