SharePoint List - get items in a folder

[GMCBoston]

Hi,

PowerBI newbie here. 

I have a list with thousands of items in it - all of which are in folders by years, such as "FY24", "FY25", etc., I've tried several times to "Export to Power BI" - which seems to work, but with one big exception - the only thing I can get to show up is the folders, not the items within the folders.

What am I missing?

Thanks!

[Anonymous]

Hi @GMCBoston ,

Based on the description, try to select sharePoint online list and choose the list wanting to connect to.

You can also view the following document to learn more information.

Create a report on a SharePoint List in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Never heard of folders inside lists. Do you maybe mean a document library?

[GMCBoston]

No. It is a SharePoint List, not a document library. 

[lbendlin]

Create a report quickly from a SharePoint list or library in the Power BI service - Power BI | Micro...

Considerations and Limitations states that only data in the root folder will show.