Forum Discussion
Solved
power query - no sharepoint folder option as data source
hi all! i have an issue with accessing files and folders from sharepoint with power query. I have business standard licence for microsoft 365, can it be the obstacle for such actions? I can not u...
From SharePoint connectors (SharePoint folders in particular) are available only for enterprise subscriptions, not for business ones.
Power Query data sources in Excel versions - Excel (microsoft.com)
You may try to M-code it directly SharePoint.Files - PowerQuery M | Microsoft Docs , not sure it works or not in such case.
szilvia_vf Perhaps you'll find your answer here:
https://www.myonlinetraininghub.com/get-data-from-onedrive-or-sharepoint-with-power-query
No, unfortunately i can nit follow the steps because I have a menu item missing. Please see my screenshot in the original post.