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.
"oh, sad story for me..."
Not so sad. Please see this easy HowTo:
https://support.cloudextend.io/en/articles/5473095-get-excel-data-from-a-single-file-or-entire-folder-on-sharepoint-or-onedrive-for-business-into-power-query-or-power-bi
I believe it is the "best answer"...
Not so sad. Please see this easy HowTo:
https://support.cloudextend.io/en/articles/5473095-get-excel-data-from-a-single-file-or-entire-folder-on-sharepoint-or-onedrive-for-business-into-power-query-or-power-bi
I believe it is the "best answer"...