Forum Discussion

Brass Contributor

Aug 18, 2021

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...

BI & Data Analysis

excel

SergeiBaklan
Aug 18, 2021
szilvia_vf

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.

SergeiBaklan

Diamond Contributor

Aug 18, 2021

szilvia_vf

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.

Gaston Huot

Brass Contributor

Jun 26, 2023

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

SergeiBaklan
Diamond Contributor
Jun 26, 2023
Gaston Huot

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?