Forum Discussion
Solved
Power Query data source settings missing SharePoint list connection option
Hi,
I seem to be missing the option for connecting to a SharePoint List, via Power Query in Excel 2016 (Office 365 version). We have an enterprise license for Office 365.
I can however create an Excel file as a result of the export-to-excel feature in SharePoint, but this alone will not solve my problem.
Any suggestions as to the reason for this?
Thx.
-S
- Hi, i believe it is because you are not on Enterprise but on a Business plan. It is only with 'E' licences you get Office ProPlus which give you the full connectors in Excel, business plans get basic features. See this: https://support.office.com/en-us/article/Where-is-Get-Transform-Power-Query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16?ui=en-US&rs=en-US&ad=US
3 Replies
- What is your build of Office?
Hi Tanya,
Here is the Office information:
-S
- Hi, i believe it is because you are not on Enterprise but on a Business plan. It is only with 'E' licences you get Office ProPlus which give you the full connectors in Excel, business plans get basic features. See this: https://support.office.com/en-us/article/Where-is-Get-Transform-Power-Query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16?ui=en-US&rs=en-US&ad=US
