Forum Discussion
Power Query missing "from SharePoint folder" option
This 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-97ff-f2e1bfa0cb16
SergeiBaklan thanks but whats the solution
IMHO, solution is to have proper subscription which support functionality you need.
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.
Don't comment documentation, but connector itself returns correct results if perform refresh properly.