Sharepoint sublists not appearing in Power Query

[AllToLearn00]

Hi there,

I'm struggling to extract the sublists of a main list in a sharepoint repository. I do have full access to the page and lists but I can only see the first three "folder" rows of the content type:

But the rest of rows related to the three sublists don't appear. Due to privacy reasons I can't provide you with .pbix files or URLs, but feel free to ask anything if I have not explained myself well enough!

Thanks,

[christinepayton]

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. 

[AllToLearn00]

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!