power query - no sharepoint folder option as data source

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?

szilvia_vf Gaston Huot 

From SergeiBaklan on Aug 18 2021: You may try to M-code it directly https://learn.microsoft.com/en-us/powerquery-m/sharepoint-files...

It's my understanding (I can be wrong) that https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16?ui=en-US&rs=en-US&ad=US actually tells you - when there's a check mark - if the option (connector) is available in the Excel menu/sub-menu and nothing else. However, it's not because i.e. SharePoint Folder doesn't appear in your menu that you can't connect to a SharePoint folder - IMHO this has to be checked

I have a 365 Home subscription and don't have SharePoint options in the Excel menus, though the SharePoint connectors are actually available in my product:

Other examples:
- JSON option not avail. in Excel 2016. After a few exchanges the OP opened a JSON file
- https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-get-data-from-pdf/1bd2afdc-2912-4b08-aae6-40250b0d589d?tm=1657958531852

To check if Sharepoint connectors are available in your product:
I don't have SharePoint in my environment so can't be detailed. Also note that from an Excel version to another the options are not exactly at the same place in the Excel User Interface so I can be precise:

#1 Download attached file SharePointOrNotSharepoint - it only contains a query > Refresh it. If no SharePoint function is listed, stop there. Otherwise...
#2 Go the Excel Data tab then navigate in the menus/sub-menus until you find option Blank Query
(It seems to be in sub-menu From Other Sources in all versions > 2013 but not sure)
#3 Select that option - The Power Query Editor should open (it auto. creates a query)
#4 In the formula bar enter exactly (ex. for a SharePoint folders) - Replace with your URL between double-quotes:

=SharePoint.Contents("https://ToBeReplacedWithYourSharePointUrl")

then Validate

NB:
- Power Query is case-sensitive (SHARePoint.FOLdER won't work)
- You might have to enter options => check the doc. https://learn.microsoft.com/en-us/powerquery-m/sharepoint-contents

If you want to know all Power Query functions (most connectors are PQ function) available in your Excel version you can download attached file PQ_AvailFunctionsInProduct and refresh the query, it'll list them all

szilvia_vf 

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 🙂