Power Query missing "from SharePoint folder" option

SergeiBaklan thanks again but 

The answer seems to be in today's MS product description gibberish; 

• Microsoft 365 Apps for Enterprise - this worked for me or
• Office 2019 Professional Plus Standalone - don't know

Either way microsoft need to take a little more care to make products less annoying to use, like making this a greyed out feature on versions it's not available on.

Perhaps its kept a secret because after hours wasted on finding this (with your help) and then trying to use it I find the feature is worthless since it is unreliable returning stale folder names.

...given its one of the most promising things MS have done in years why dont they just fix these many annoyances - we can only wonder.

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