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.
Unless there is something I don't understand, this is not the "best solution" to the OP. The best solution comes from another web site: https://support.cloudextend.io/en/articles/5473095-get-excel-data-from-a-single-file-or-entire-folde...
I have business (Standard) M365 edition (not Enterprise), and it works perfectly for me. Can someone say otherwise?
Gaston
I have business (Standard) M365 edition (not Enterprise), and it works perfectly for me. Can someone say otherwise?
Gaston
OP question was why From SharePoint Folder connector is missed. Post you mentioned explains how to work witch such connector assuming it exists. Actually it repeats information from the post link on which gave Riny_van_Eekelen in his answer.
By the way, did you have that connector on your subscription an year ago or it appeared in recent months?