Aug 12 2020 12:20 AM
Hey All,
I am trying to connect to a sharepoint folder, However the option is just missing, I keep seeing guide that tell me to use the option but I don't have it.
I have a microsoft office 365 business premium account
Thanks in advance.
Aug 12 2020 12:41 AM
SolutionThis connector is not available for Business Premium, please check here https://support.microsoft.com/en-us/office/where-is-get-transform-power-query-e9332067-8e49-46fc-97f...
May 20 2021 02:01 PM
May 21 2021 01:36 AM
You may try to install Power Query from here Download Microsoft Power Query for Excel from Official Microsoft Download Center but for SharePoint connector you have to have Pro version of Office.
Please note
May 21 2021 04:19 AM - edited Jan 09 2023 08:37 PM
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:
=SharePoint.Files("<TheRootAddressOfTheSharepointSite>", [ApiVersion=xx])
(for xx, check the function doc.)
See i.e. Connecting to Files in SharePoint & OneDrive with Power BI / Power Query that discusses the diff. between SharePoint.Files & SharePoint.Contents
May 21 2021 08:57 AM
As a comment, I'm not sure add-in for 2013 supports ApiVersion mentioned in documentation (I guess 15). Better to skip or use null. Or use one which appears by default for this version of PQ.
May 21 2021 09:38 PM
May 22 2021 04:43 AM
ApiVersion 14 was buggy, #15 is also not free of bugs but it is updated from time to time. In any case that's not a good idea to use PQ last updated couple couple of years ago, but perhaps for the concrete task it works.
Jan 08 2023 06:23 PM
@Sergei Baklan thanks but whats the solution
Jan 09 2023 10:58 AM
IMHO, solution is to have proper subscription which support functionality you need.
Jan 10 2023 09:40 PM
@Sergei Baklan thanks again but
The answer seems to be in today's MS product description gibberish;
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.
May 13 2023 09:22 AM
May 22 2023 07:15 AM
That's okay, but doesn't answer on question why the connector could be missed and why it could work differently on this or that version of Power Query.
May 22 2023 07:16 AM
Don't comment documentation, but connector itself returns correct results if perform refresh properly.
May 22 2023 07:27 AM
Aug 12 2020 12:41 AM
SolutionThis connector is not available for Business Premium, please check here https://support.microsoft.com/en-us/office/where-is-get-transform-power-query-e9332067-8e49-46fc-97f...