Power Query missing "from SharePoint folder" option

Timo1950 

Once you have the Power Query Add-in installed...
Create a new blank (Power) query > Advanced Editor > Select all > Paste this code:
(gives you a table of all PQ M functions available in the used product - the PQ Add-in in your case)

let
    // #shared library excluding this workbook's Queries & custom functions
    Source = Record.ToTable(
        Record.RemoveFields(#shared,
            Record.FieldNames(#sections[Section1])
        )
    ),
    SelectedTypeFunction = Table.SelectRows(Source, each [Value] is function),
    RemovedValue = Table.SelectColumns(SelectedTypeFunction, {"Name"}),
    SortedByName = Table.Sort(RemovedValue, {{"Name", Order.Ascending}}),
    RenamedColumn = Table.RenameColumns(SortedByName,
        {{"Name", "Function name"}}
    )
in
    RenamedColumn

Check the list but top of my head functions https://docs.microsoft.com/en-us/powerquery-m/sharepoint-contents, https://docs.microsoft.com/en-us/powerquery-m/sharepoint-files & https://docs.microsoft.com/en-us/powerquery-m/sharepoint-tables should be there. AFAIK there's no restriction to access a Sharepoint site as long as you have the appropriate credentials, in which case:

• Create a blank query
• In the PQ Editor formula bar enter:

=SharePoint.Files("<TheRootAddressOfTheSharepointSite>", [ApiVersion=xx])

(for xx, check the function doc.)

• Validate (you'll be asked for your Credentials) and you should get what you need

See i.e. https://www.poweredsolutions.co/2019/04/04/connecting-to-files-in-sharepoint-onedrive-with-power-bi-power-query/ that discusses the diff. between SharePoint.Files & SharePoint.Contents