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...
I too have Business Standard; however, Microsoft must have recently acted on this because up until a few days ago, I had the choice to "get data from file/ From SharePoint Folder 🙂
kimyboo , good to know, thank you for sharing.