Forum Discussion
SharePoint List - get items in a folder
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!
4 Replies
Never heard of folders inside lists. Do you maybe mean a document library?
No. It is a SharePoint List, not a document library.
Considerations and Limitations states that only data in the root folder will show.
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.
