@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 SharePoint.Contents, SharePoint.Files & 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. Connecting to Files in SharePoint & OneDrive with Power BI / Power Query that discusses the diff. between SharePoint.Files & SharePoint.Contents
