Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I know Shrepoint.Tables( ) connector is usually used to load a Sharepoint list.
However, is it possible to load a list using Sharepoint.Contents( ) connector ?
When I navigate to the desired list using Sharepoin.Contents( ), I get this :
which only has the attachments and the forms but not the list content.
Any idea why ?
Where is the list content ?
Solved! Go to Solution.
No, you cannot directly load a SharePoint list using SharePoint.Contents() in Power Query. SharePoint.Contents() is used to access the contents of a SharePoint site, such as document libraries and folders, but to specifically access a SharePoint list, you should use SharePoint.Lists() instead. This function allows you to retrieve data from a specific SharePoint list, making it more suitable for working with list data directly.
No, you cannot directly load a SharePoint list using SharePoint.Contents() in Power Query. SharePoint.Contents() is used to access the contents of a SharePoint site, such as document libraries and folders, but to specifically access a SharePoint list, you should use SharePoint.Lists() instead. This function allows you to retrieve data from a specific SharePoint list, making it more suitable for working with list data directly.
Noted and thanks !
I believe that should be SharePoint.Tables() and not SharePoint.Lists()
SharePoint doesn't store files quite how you expect. It necessary for the content connector to differ from the list connector due to this backend distinction.
The SharePoint front end does a great job of fooling you into thinking that that structure is what the backend looks like. Its not. Its much more flat.
Noted and thanks
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
37 | |
31 | |
26 |