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...
- 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
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