Forum Discussion
Solved
Power Query missing "from SharePoint folder" option
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.
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
- Please see this easy HowTo:
https://support.cloudextend.io/en/articles/5473095-get-excel-data-from-a-single-file-or-entire-folder-on-sharepoint-or-onedrive-for-business-into-power-query-or-power-bi
The real solution.
I believe it is the "best answer"...
GastonThat'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.
- That's right, but at least we can do it, can't we ? Let us proclaim the mystery of Microsoft.
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.
- Hello Sergei. What about Office 2013? How I can create SharePoint folder connection with Excel? Thank you!
- Thank you Sergei
